Avoid div/0 error?

[MsCynic]

Hi guys, when dragging a cell down to repeat a formula throughout a column, what is the trick that avoids having the #DIV/0! error display on rows without data in them?

Thanks in advance,
C

 

[mikerickson]

In a macro,

if IsNumeric(denominator) and CDbl(denomiator)=0 then ... will protect your formula.

On a spreadsheet

=IF(iserror(a1/b1),"",a1/b1) will return the emptrystring rather than a #DIV/0 errror.

 

[mypig7]

In =IF(B1,A1/B1,"")

Can you explain the 1st bit. =IF(B1, I have used IFs before but am used to having a condition at the start e.g. =IF(b1>0

Cheers

 

[mikerickson]

0 evaluates to FALSE in the conditional part of an IF.

IF(b1,a1/b1,"")

is the same as IF(NOT(b1=0),a1/b1,"") in this case.

 

[mypig7]

thanks

many thanks

C