#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.
 
Top