Within a range....

  • Thread starter Thread starter Tubthumper
  • Start date Start date
T

Tubthumper

Hi

I need a formula that will tell me whether B1 is within a
tolerance of +/- 10% of the value of A1. I'm sure that
there is an easy way....

Thanks folks

Tubthumper
 
Frank Kabel said:
try
=IF(ABS(B1-A1)/A1<=0.1,"within range","outside range")
Click to expand...
....

This probably works for the OP, but the condition would be tautologically
true if A1 were negative. Safer to cancel like terms,

=IF(ABS(B1/A1-1)<=0.1,...)
 
Back
Top