divide by zero

  • Thread starter Thread starter arknsparc
  • Start date Start date
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 ???
 
Perhaps....
=if(X45=0,"Zero Divisor",(x43-x45)/x45)

Replace Zero Divisor with any error message you wish.

Vaya con Dios,
Chuck, CABGx3
 

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

dividing 0 by 0 in excel 2003 10
Sumproduct Repeatability 3
Divide by zero error 3
divide by zero error 5
Dividing - Negative Number by Zero 5
Div 0 help 1
REALLY NEED HELP ON THIS ONE. 5
Dividing by zero 2

Back
Top