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

[Sean]

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


Thanks

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Sean]

Thanks Pete, just figured it out using ABS

 

[Pete_UK]

You're welcome, Sean.

Pete