divide by zero

M

Meebers

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

Rick Rothstein

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)
 
M

Meebers

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
 
D

David Biddulph

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA multiple list of values for variable 1
Macro to get rid of #DIV/0! 2
If, Or, and 5
Referencing the values of multiple cells in conditinal formatting. 0
problem with time subtraction 7
Divide by the minimum non-zero number in a range of cells 22
Nameing a function 1
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6

Top