Say, in cell A1, you have =180*21850, in cell B1, you have 3933000. Then in cell C1, you have the formula =IF(B1>A1,B1-A1,A1-B1), which Excel computes to be zero

However, if I do it slightly differently as follows:
in cell A2, you have =3420000*1.15, in cell B2, you have 3933000. Then in cell C2, you have the formula =IF(B2>A2,B2-A2,A2-B2), which Excel returns the value -4.65661E-10.

Is this a bug? I would expect Excel to return the value 0 in cell C2 too. Everything is in nice whole numbers.


Thank you for your help!