Formula to ask if there is more than 10% difference between result
 

i have to calculate from a results sheet if there is more than a 10%
difference between two results (simple numeric results) calculated from
experimental data to determine wether or not to run a third sample. The
results are in column format and are typically numbers from eg: 0.344 to 9.7
the query is to tell if cells eg: a1 and a2 have more than a 10% disparity
preferably always using the lower number to calculate the 10% variation.

Can anyone shed some light on this for me please. have tried my best but not
having any luck!

Formula to ask if there is more than 10% difference between result
 

=ABS(A1-A2)/MIN(A1:B1)10%
=IF(ABS(A1-A2)/MIN(A1:B1)10%,"Repeat","OK")
=IF(ABS(A1-A2)/MIN(A1:B1)10%,"Repeat","")
use whichever suits your needs
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"AMCD" wrote in message
...
i have to calculate from a results sheet if there is more than a 10%
difference between two results (simple numeric results) calculated from
experimental data to determine wether or not to run a third sample. The
results are in column format and are typically numbers from eg: 0.344 to
9.7
the query is to tell if cells eg: a1 and a2 have more than a 10% disparity
preferably always using the lower number to calculate the 10% variation.

Can anyone shed some light on this for me please. have tried my best but
not
having any luck!

Formula to ask if there is more than 10% difference between result
 

On Mar 21, 7:39 am, AMCD wrote:
the query is to tell if cells eg: a1 and a2 have more than a 10% disparity
preferably always using the lower number to calculate the 10% variation.

=if(abs(a1-a2)/min(a1,a2)10%, true, false)

Caveat: This assumes that both A1 and A2 are greater than zero.