| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
divide by zero
need to calculate error from zero...
typical working formula is (x43-x45)/x45 for percentage of error. these calculations provide values of error for calibrations over a range of values that take place in our facility. for an error however that occurs based on the zero value this formula understandably displays formula error div/0. eg.. calibration expected 4.00ma. measured 4.18ma results in an error of 0.045 (4.18-4.00)/4.00 = 0.045 calibration expected 0inH2O. measured 0.8inH2O results in error DIV/0 how best to handle this ??? -- instrumentation engineer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide by zero
Perhaps....
=if(X45=0,"Zero Divisor",(x43-x45)/x45) Replace Zero Divisor with any error message you wish. Vaya con Dios, Chuck, CABGx3 "arknsparc" wrote: need to calculate error from zero... typical working formula is (x43-x45)/x45 for percentage of error. these calculations provide values of error for calibrations over a range of values that take place in our facility. for an error however that occurs based on the zero value this formula understandably displays formula error div/0. eg.. calibration expected 4.00ma. measured 4.18ma results in an error of 0.045 (4.18-4.00)/4.00 = 0.045 calibration expected 0inH2O. measured 0.8inH2O results in error DIV/0 how best to handle this ??? -- instrumentation engineer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide | Excel Discussion (Misc queries) | |||
| Divide by 3 | Excel Discussion (Misc queries) | |||
| divide by 0 | Excel Worksheet Functions | |||
| Divide by Zero | Excel Worksheet Functions | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Linear Mode
