#DIV/0! error

S

Sand

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?
 
G

Gary''s Student

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.
 
S

Sand

This is for a time card the formula is =SUM(E14+M14)+(E14/I14*K14) I'm not
great at fancy programing.
 

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

MS Project - error message when checking "Critical tasks" 1
I can create Publisher documents, but I can not open / read them. 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
How do I make #DIV/0! error message go away? 2
Supress DIV/0 2
You don't currently have permission to access this folder 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
#DIV/0 error 3

Top