Nested If With And
Creating a RAG report where i will format background Red Amber Green based on the values in 2 columns.
RULES
If col H is greater than 1 then it is GREEN.
If col H is less than 1 AND col K is less than 1, then RED
If col H is less than 1 AND col K is greater than 1 then AMBER
Here is how I wrote it…
=
IF(H1>=1,”Green”,
IF(AND(H1<1,K1<1),”Red”,
IF(AND(H1<1,K1>=1),”Amber”)))
It doesn’t seem to be giving me the correct data. Some are right, some are wrong.
Creating a RAG report where i will format background Red Amber Green based on the values in 2 columns.RULESIf col H is greater than 1 then it is GREEN.If col H is less than 1 AND col K is less than 1, then REDIf col H is less than 1 AND col K is greater than 1 then AMBER Here is how I wrote it…=IF(H1>=1,”Green”,IF(AND(H1<1,K1<1),”Red”,IF(AND(H1<1,K1>=1),”Amber”)))It doesn’t seem to be giving me the correct data. Some are right, some are wrong. Read More