simple formula

[Guest]

I want to find out the difference between two numbers and if its more than
certain amount identidy it.

Eg. -1.3445 , 1.4554, the difference between these two nos, should be less
than 0.1 . but when i try to write the if formula dosent wrk out the way i
wanted.

i did these functions several years ago, i was wondering am i missing
something or function wont work with minus nos. ?????

Helpppppppppp......

 

[Niek Otten]

Why not give us your formula and the results?

=IF(B1-A1<0.1,"","Too much difference!")

 

[Guest]

I was trying to put -0.1 in the formula thats giving me wrong answer but 0.1
woks fine thank you.

 

[Niek Otten]

Maybe better:

=IF(ABS(B1-A1)<0.1,"","Too much difference!")