Why not give us your formula and the results?

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

--
Kind regards,

Niek Otten

"amharan" wrote in message
...
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......