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”,""))))

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

message edited by mmcconaghy

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

Ask Your Question

Weekly Poll