#name or #div/0 problem

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

Guest

I am dividing two cells. Sometimes there is a "0" in the denominator and it
gives me the error message. I tried writing an "if" statement but have not
been successful. I am trying to create a blank cell when there is no value.
I tried changeing the fomate from custom "-" to number and can't seem to get
it to work. Can someone please help.

Thanks,
Jay
 
Try somthing like this

replace cell ref as required

=IF(ISERROR(A15/B15),"",A15/B15
 
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 2
Div 0 help 1
Blank value rather than #DIV/0! 1
When dividing by 0 can i show a result of 0 instead of #DIV/0 7
#DIV/0! in variance/percentage formula 3
Div/0 2
#Div/0! 4
#DIV/0! error 1

Back
Top