| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difference between + or = in entering a formula | Excel Worksheet Functions | |||
| date difference formula | Charts and Charting in Excel | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
Threaded Mode
