#DIV/0 error

[duewaynec]

hi,

how do i get rid of this error when values are zero's and it needs to be divided. is there a way to get it to display a zero as well?

 

[jdc]

Hi

Use ISERROR in your formula,

ie =IF(ISERROR(A1/B1),0,A1/B1)

John

 

[duewaynec]

thanks. works perfectly

 

[Brian from Maui]

hi,

how do i get rid of this error when values are zero's and it needs to be divided. is there a way to get it to display a zero as well?

Filter the divisor with an IF, no need for ISERROR.

 

[duewaynec]

ok so heres one formula that produces the #DIV/0 error i'm trying to get rid of.

=SUM(C31/(C21+C22+C25+C26+C27))
the result is in percentage format.
this results in the error if any of the cells being added has a value of zero.

 

[~Zodiac~]

Range("C21").Select
Cell1=ActiveCell.Address
Range("C22").Select
...

if Cell1="0" or Cell2="0" or Cell3="0" or Cell4="0" or Cell5="0" then
range(TargetCell).Select 'Change this to whatever your calculating cell is
ActiveCell.Value="0"
Else
range(TargetCell).Select
ActiveCell.Formula="=SUM(C31/(C21+C22+C25+C26+C27)) "
end if


HTH

edit: defining Cells and putting the value Cellnumber in the if.

 

[Brian from Maui]

ok so heres one formula that produces the #DIV/0 error i'm trying to get rid of.

=SUM(C31/(C21+C22+C25+C26+C27))
the result is in percentage format.
this results in the error if any of the cells being added has a value of zero.

Try,

=C31/SUM(MAX(1,(C21:C22,C25:C27)))