“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

logical formula and or xor need help on spreadsheet

Solved by D. J. in 26 mins

I need to repeat y axis on opposite side of the stack area plot for easy readability. How can I do it?

Solved by A. E. in 14 mins

I need a formula to reverse distance in feet between several segments e.g 0,1000,4500,10000.........reverse the same the opposite way calculating the distance between 10000,4500,1000,0

Solved by V. Y. in 13 mins

Hi,
I need a formula that will separate a text string into two cells. The opposite of concat. For example:
Last name, First name (cell1A) into Last name (cell 2A) and first name (cell 3A).
Thank you,

Solved by K. L. in 14 mins

I am using conditional formatting for this scenario. It seems to work as an all or nothing option and I am trying to separate that. For example currently the formula changes to green if the variables are met. If one of those fall outside the guidelines it changes everything back to green even though 1 of the variables could still be met.
=OR(AND(D$1>=5,D$2>=5,D$3>=2,D$4>=2),AND(D$1>=4,D$2>=4,D$3>=3,D$4>=3))
Help please.
I even tried to do some separation such as:
=XOR(D$1>=5,D$2>=5,D$3>=2,D$4>=2)
=XOR(D$1>=4,D$2>=4,D$3>=3,D$4>=3)

Solved by V. B. in 11 mins