For your revised question, try
=IF(OR(B1=0,A1=""),"",A1/B1)

I assume that if you have a zero in A you want to show zero for the result,
but if you have a blank in A you want a blank result?
--
David Biddulph

"Meebers" wrote in message
...
Tx Rick and David, yes I wanted "" in either condition. no data in A
gives me a "0" and no data in B gives me #DIV/0! My question should have
been "so as not to produce a "0" or #DIV/0!" In other places on the
sheet, I want a 0 (zero) and therefore opting for do not show 0 values was
not chosen. TIA

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(B1=0,"",A1/B1)
--
David Biddulph

"Meebers" wrote in message
...
If in cell c1 I have a formula =a1/b1 and either one or both are empty,
how do I check for that so as not to produce a divide by 0.