Hi,
I'm trying to write and IF statement that also, i think, requires an AND function, and I'm having trouble.
Here's what I'm trying to say in plain English:
IF A3 is less than A2, return RED
If A3 is less than A2 and A2 is less than A1, return LIGHTRED
IF A3 is greater than A2, return Green
If A3 is greater than A2 and A2 is greater than A1, return LIGHTGREEN
Here's what I've written so far but it's not working:
=IF(A3 < A2,"RED",IF(A3 > A2,"GREEN",IF(AND(A3 < A2),(A2 < A1),"LIGHTRED",IF(AND(A3 > A2),(A2 > A1),"LIGHTGREEN")))
Any help would be appreciated.
chaos
I'm trying to write and IF statement that also, i think, requires an AND function, and I'm having trouble.
Here's what I'm trying to say in plain English:
IF A3 is less than A2, return RED
If A3 is less than A2 and A2 is less than A1, return LIGHTRED
IF A3 is greater than A2, return Green
If A3 is greater than A2 and A2 is greater than A1, return LIGHTGREEN
Here's what I've written so far but it's not working:
=IF(A3 < A2,"RED",IF(A3 > A2,"GREEN",IF(AND(A3 < A2),(A2 < A1),"LIGHTRED",IF(AND(A3 > A2),(A2 > A1),"LIGHTGREEN")))
Any help would be appreciated.
chaos