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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=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
 
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.
Click to expand...

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

Caveat: This assumes that both A1 and A2 are greater than zero.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Result is different from the shown result 2
Offset/Match when there is more than 1 result 3
1 Vlookup multiple results in different columns 5
Difference between two dates rounded up. 4
Help Pls Copy 1 Random Result To Many On Another Sheet? 2
HELP! I need to make an IF Statement comparing date/time fields.. 2
Sum the difference between dates given a certain criteria 5
how to set up formula with more than 1 result 5

Back
Top