operation with excel

[GJ]

Hi,
I don't undestand why I don't have the same result with these two formulas :

=IF(1.02-1.01=0.01,"ok","not ok") => the result is : ok

=IF(2.02-2.01=0.01,"ok","not ok") => the result is : not ok

Thanks

GJ

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/rounding.htm

So use
=IF(ROUND(2.02-2.01,2)=0.01,"ok","not ok")

 

[Gord Dibben]

GJ

If you enter the two operations directly in cells

=2.02-2.01 returns 0.01

=1.02-1.01 returns 0.01

Now increase the decimal point to about 15 and you will see the first is
0.0100000000000200

And the other is 0.010000000000000 forever.

Excel's method of dealing with floating point math.

Others will undoubtedly explain the reason for this. Keep posted.

Gord Dibben Excel MVP