Hi Everyone,

Thanks for all the responses. It seems the issue hereis going into decimals.
I'm goint to try the suggestions. Another option I'm considering is to have
a secondary cell where c1=a1*10000. which means the value goes to 2999 and
not1.2999. This will then take the value for the sake of the logical formula
out of decimals, thus 12999 and 13000. Will keep posted.

Thanks again



"Chris Vermaak" wrote:

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