IF Function not working with subtraction

[des378]

Not sure what I'm doing wrong here or if this is a glitch in Excel,

EX:
A1 = 50.50
A2 = 50.10
A3 = 0.40

A4 = ((A1)-(A2)-(A3))

FORMULA:
IF(A4=0,"Equal to Zero","Not Zero")

For some reason the function always returns "Not Zero" even though A4 equates to 0.

How do I fix this? Thanks in advance

 

[FormR]

Hi, it's a floating point rounding error. See here.

One way to resolve it is to apply some rounding. i.e.

Book2
	A
1	50.5
2	50.1
3	0.4
4	0
5	Equal to Zero
Sheet1

Cell Formulas
Range	Formula
A4	A4	=ROUND(A1-A2-A3,13)
A5	A5	=IF(A4=0,"Equal to Zero","Not Zero")

 

[des378]

Hi, it's a floating point rounding error. See here.

One way to resolve it is to apply some rounding. i.e.

Book2
	A
1	50.5
2	50.1
3	0.4
4	0
5	Equal to Zero
Sheet1

Cell Formulas
Range	Formula
A4	A4	=ROUND(A1-A2-A3,13)
A5	A5	=IF(A4=0,"Equal to Zero","Not Zero")

Thanks for this!

In my completed formula I use the CONCAT function as well with the IF function and solved it using the ROUND function to compare if the number is equal to 0.

 

[Peter_SSs]

@des378
Given that the gist of the solution was to ROUND, and that was suggested by @FormR, I have moved the 'solution mark' to post #2