Hi,

Am Tue, 25 Mar 2014 11:26:02 -0700 (PDT) schrieb :

Do this give me 15% above or below the number or just equal to or less than?
this what i'm trying to accomplish

both because of ABS

C3=allowable BIAS (15%)

c6=1.21 DXA analyzer(sample 1)
d8=1.34 DXB analyzer(sample 1)
e8=%diff
F8= this in where i want know if the %diff is higher or lower than 15% if so say "NO" if Not it is acceptable range and "YES" will be acceptable for comparison

Try in F8:
=IF(ABS(E8<=C3),"Yes","No")


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