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
|