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