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.
do I check for that so as not to produce a divide by 0.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
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
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
R
Rick Rothstein
Then it sounds like you want this formula...
=IF(OR(A1=0,B1=0),"",A1/B1)
=IF(OR(A1=0,B1=0),"",A1/B1)
M
Meebers
Thanks to both...you get extra points!
Rick Rothstein said:Then it sounds like you want this formula...
=IF(OR(A1=0,B1=0),"",A1/B1)