A
arknsparc
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 ???
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 ???