simple formula
 

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......

simple formula
 

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......

simple formula
 

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

"Niek Otten" wrote:

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......

simple formula
 

Maybe better:

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

--
Kind regards,

Niek Otten

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

"Niek Otten" wrote:

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......