Strange results

[qjsbarrick]

When I type in A1 152.2 and in B1 152.6 then C1 = B1-A1 I get the result 4.0 if I expand the number of decimal places I get <table style="border-collapse: collapse; width: 161pt;" width="214" border="0" cellpadding="0" cellspacing="0"><col style="width: 161pt;" width="214"><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 161pt;" width="214" align="right" height="20">0.4000000000000060000</td> </tr></table> If I then enter the following formula in D1

=IF(B1-A1=0.4,"True","False")

I get the result False.

Can someone please explain this.

Thanks

Quentin

 

[Boller]

http://support.microsoft.com/kb/78113

 

[Armando Montes]

Here is a good explanation:
http://blogs.office.com/b/microsoft...es-excel-give-me-seemingly-wrong-answers.aspx

 

[qjsbarrick]

Thanks Armando Montes and Boller for the explanations.
It seems to be a larger problem not only in Excel but also in my SQL calculations. I have used the ROUND() function to set the number of decimal places to 2 and it all seems OK at this stage. Something to remeber in the future.

Thanks