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?


See More: Nested IF/AND statement error

Report •

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.


message edited by mmcconaghy

Report •

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.


message edited by jlriley177

Report •
Related Solutions

Ask Question