Express a Formula that is + or - 20% from a Value Q
 

How can I express a formula that checks to see if a value is within +
or - 20% from another value?


Thanks

Express a Formula that is + or - 20% from a Value Q
 

Try this:

=IF(ABS((B1-A1)/A1)<=0.2,"OK","Out of tolerance")

Hope this helps.

Pete

On Jan 14, 10:40*am, Sean wrote:
How can I express a formula that checks to see if a value is within +
or - 20% from another value?

Thanks

Express a Formula that is + or - 20% from a Value Q
 

Thanks Pete, just figured it out using ABS

Express a Formula that is + or - 20% from a Value Q
 

You're welcome, Sean.

Pete

On Jan 14, 11:13*am, Sean wrote:
Thanks Pete, just figured it out using ABS