Hi Paul,

Am Tue, 25 Mar 2014 09:53:05 -0700 (PDT) schrieb :

I want to create a field that will give a "YES" or "No" if the number in CEll A1 is not 15 percent higher or lower than cell A2 "YES"

try:
=IF(ABS(1-A1/A2)<=0.15,"Yes","No")


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional