#DIV/0! error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I seem to get this error message in some cells I'm working in. The answer
come out correct but I want to hide the error message how do I do this?
 
This usually happens because the divisor hasn't been entered yet. In place
of =A1/B1 use something like =IF(B1=0,"",A1/B1).

Basically don't divide if you know you can't.
 
This is for a time card the formula is =SUM(E14+M14)+(E14/I14*K14) I'm not
great at fancy programing.
 
Back
Top