#name or #div/0 problem
 

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

#name or #div/0 problem
 

Try somthing like this

replace cell ref as required

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553841