#name or #div/0 problem

S

sjl

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
 
V

VBA Noob

Try somthing like this

replace cell ref as required

=IF(ISERROR(A15/B15),"",A15/B15
 

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 help 1
#DIV/0! displayed in Pivot Tables 0
#DIV?0! in Pivot Table 0
#div/0 error 2
When dividing by 0 can i show a result of 0 instead of #DIV/0 7
$DIV/0! 3
#DIV/0! in variance/percentage formula 3
#DIV/0! 3

Top