duewaynec said: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?
duewaynec said: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.