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