On Tuesday, March 25, 2014 2:28:07 PM UTC-2:30, Claus Busch wrote:
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")


Thanks for your response!

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

I have two sample number that come of two different Laboratory analyzers

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

Thanks,
Paul









Regards

Claus B.

--

Vista Ultimate SP2 / Windows7 SP1

Office 2007 Ultimate SP3 / 2010 Prodessional