Forum Discussion
Basic IF Function Not working
Hi, I cannot figure out why this basic IF function isn't working - is it a glitch or is there something I am missing? EX: A1 = 50.87 A2 = 50.32 A3 = 0.55 A4 = ((A1)-(A2)-(A3)) FUNCTIO...
This is due to (unavoidable) tiny rounding errors. Try
=IF(ROUND(A4, 2)=0, "Equal to Zero", "Not Zero")
I rounded to 2 decimal places since the input cells A1:A3 have 2 decimal places.