#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.
 
You must log in or register to reply here.

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

#DIV/0 error 3
#DIV/0! error when using COUNT 4
#div/0 array 1
#DIV error 5
#DIV/0! Error & IF, THEN Condition Formula 2
Supress DIV/0 2
Average Error 1
Alert Errors need to be either Blank or "$0.00" 5

Back
Top