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, "red",
0.49 to 0 , AMBER refer the column - j2<=0.49, t2<=0.49, "Amber".
=IFS(OR(J2>=0.5, T2>=0.5),"GREEN",OR(J2<=0.01,T2<=0.01),"RED",OR(J2<=0.49, T2<=0.49),"AMBER").
when i try this same i am getting error, values 0.03 suppose this should be AMBER but its shows RED i have attached this same image . please help me the issue.
7 Replies
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.
