Return Red Amber Green
I wish to return a single rag status from two columns. The two Columns will display "Yes" or No individually.
If both columns are "Yes" I wish to return Green
If one column is "Yes" and the other "No (or vice versa) I wish to return Amber
If both columns are "No" I wish to return Red
I am not sure which function I should be using (IF, IF AND) and how to write the syntax
I appreciate any help as I am a novice and thank you in advance
Help Article Resources
Check out the Formula Handbook template!