Hi-
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"

Thanks,
Paul

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

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

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

On Tuesday, March 25, 2014 2:23:05 PM UTC-2:30, wrote:
Hi-

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"



Thanks,

Paul

Claus,

Thanks for the help!

Don't seem to be working right, but may be what i have for the percentage of the difference formula

VAL= =IF(C8="","",(((C8-D8)/ABS(D8))))

c8=1.56
d8=1.86
e8=-16%
f8 = yes
b3=12%