View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Vermaak Chris Vermaak is offline
external usenet poster
 
Posts: 1
Default numeric calculation in logical formula

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