Forum Discussion
J-Des000
Jan 08, 2025Brass Contributor
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))
FUNCTION:
IF(A4=0,"Equal to Zero", "Not Equal")
This function always returns "Not Equal" - any reason why/what am I doing wrong?
Thanks in advance!
1 Reply
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.