Forum Discussion

kitcatnj's avatar
kitcatnj
Copper Contributor
May 01, 2024

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.

 

Resources