A1=B1 plus or minus tolerance!HELP ME PLEASE!

[jiffy]

hi all! can anyone help me!
below is an example of what i am trying to achieve but cannot find th
correct formula to do it.

in cell (a1) the number 2470.56
in cell (b2) the number 2471.32
i know there is the formula (a1=b2)would give you a true/false answer.
but what i am after is for the a1=b2 to have a plus or minus toleranc
of say 2 points or the number 2.
so that the above numbers in cells a1 and b2 WILL EQUAL each other an
give a TRUE answer rather than a FALSE answer.
obviously if the numbers were more than 2 points apart then the answe
WILL BE FALSE.

can anyone help me it would be greatly appreciated.
thxs
jiff

 

[Frank Kabel]

Hi
one way:
=AND(A1<=B1+0.02,A1>=B1-0.02)
Frank

 

[jiffy]

thankyou frank, for your quick response and your help.
have a great week.
your one in a million.
jiff

 

[Frank Kabel]

Hi
thanks for the feedback
Frank

 

[Tushar Mehta]

You can shorten Frank's answer to =ABS(A1-B2)<=0.02. I often put the
threshold (0.02, in this case) in a separate cell, say G1. Then, the
formula becomes =ABS(A1-B2)<=$G$1. Now, if I want to change the
threshold to some other number, only one cell, G1, needs to be changed.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions