Thanks to both...you get extra points!

"Rick Rothstein" wrote in message
...
Then it sounds like you want this formula...

=IF(OR(A1=0,B1=0),"",A1/B1)

--
Rick (MVP - Excel)


"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.