Forum Discussion
Ifs negative values error
Dear All, I hope doing great, kindly help me for the below error, i want check 3 condition, =IFS(M1>=0.5, "GREEN",M1<=0.5," AMBER",M1<=-0.1,"RED") like A>=0.5, GREEN, A<=0.5, AMBER, A...
SUDHAKAR-FRONTIER Try it this way:
=IFS(M1>=0.5, "GREEN",M1<=-0.1,"RED",M1<=0.5," AMBER")Your original formula never came past the AMBER test as a number <= -0.1 is also <= 0.5 . So, you need to put the RED test before the AMBER test.