divide by zero
 

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.

divide by zero
 

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.

divide by zero
 

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

divide by zero
 

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.

divide by zero
 

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.

divide by zero
 

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.

divide by zero
 

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.