Solved Nested IF/AND statement error

February 3, 2017 at 14:34:45
Specs: Windows 7
I am getting and error messages when putting these statements together. What am I missing?

IF(AND(R3>=1,S3>=0),”Red”,IF(AND(R3=0,S3>=1)),”Yellow”,IF(AND(R3=0,S3=0),”Green”,""))))


See More: Nested IF/AND statement error

Report •

#1
February 3, 2017 at 16:47:02
✔ Best Answer
It's your quote marks,

”Red” ”Yellow” ”Green”

should be

"Red" "Yellow" "Green"

This usually occurs if you use a word processor or some other program to write the formula.

Also, Excel questions are best asked in the Office Software forum.


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
February 3, 2017 at 17:59:10
That is strange, I'm not sure why it did that. I created the formula in Excel.

I started over and also removed the extra parenthesis and it's working now! Thanks for the quick reply and I'll remember that info about the quote marks.

IF(AND(R3>=1,S3>=0),"Red",IF(AND(R3=0,S3>=1),"Yellow",IF(AND(R3=0,S3=0),"Green","")))

message edited by jlriley177


Report •
Related Solutions


Ask Question