Forum Discussion
IF function error
Dear Friends, Kindly help me the below error, i have written the IF condition like 0.50 > GREEN, Refer the column - j2>=0.50, t2>=0.50, "green", 0< RED, Refer the column - j2<=0, t2<=0, "re...
SUDHAKAR-FRONTIER You need to use AND in stead of OR.
This formula will result in AMBER in U2.
=IFS(AND(J2>=0.5, T2>=0.5),"GREEN",AND(J2<=0.01,T2<=0.01),"RED",AND(J2<=0.49, T2<=0.49),"AMBER")
SUDHAKAR-FRONTIER An image is no good. I'd need the file to look at.
Please find the Attached file.
If possible kindly help (b2<=10.00, c2<=10.00) "GREEN +",
Between 50 to 10 need to display Green.
SUDHAKAR-FRONTIER Well, with this data it seems that OR in all three conditions works as intended. It didn't when I replicated the data from your initial data set.