RYG-ball with nested IF statement (combined with AND)
I simply want to change the status of a RYG-ball by comparing two conditions.
If Condition1 AND Condition2 are FALSE than the ball should be RED.
If Condition1 AND Condition2 are TRUE than the ball should be GREEN.
In any other case the ball should be YELLOW.
When building the formula, this worked as an intermediate result
=IF(AND(Condition1 = 0; Condition2 = 0);"Red";"Green")
but adding an additional condition ended up with UNPARSABLE:
=IF(AND(Condition1 = 0; Condition2 = 0); "Red";IF(AND(Condition1 = 1;Condition2 = 1); "Green; "Yellow"))
I know this is not rocket science, but I am stuck. Help articles did not really help me. I guess it's the syntax or brackets.
Can someone have a quick look on my problem?
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!