Hi,

Can anyone explain this highly irritating issue please?

I'm using the following formula:

=IF(A146=0,0,E145+C146-D146)
where E145 = -5089.22
and C146 = 5089.22
and D146 = 0
which produces effectively -5089.22 + 5089.22 as shown below.
Capture 1.JPG


This then calculates at the next step as 1.8189E-12 rather than 0.
Capture 2.JPG

Yet when I do E145 + C146 it works out fine.

Any ideas anyone please????!!!!