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