View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AMCD AMCD is offline
external usenet poster
 
Posts: 5
Default 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!