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.

The divide by zero error will only happen when B1 equals zero, so just test
for that condition. Unfortunately, you didn't say what you want to happen
for this condition, so I'll just show ??? in the cell (change that to
whatever you want)...

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

--
Rick (MVP - Excel)


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

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

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.

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.

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.

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.