Interesting. When I do b1-a1 (only), I get this result:
0.0000999999999999890


*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Chris Vermaak" <Chris wrote in message
...
cell a1 = 1.2999, cell b1=1.3000

I want a "if" formula like this:

=if(((b1-a1)=0.0001),true,false)...it seems in the logical formula, the
calculation is ignored and it always gives a false result.

Can anybody help how to do it??

Thanks