Percentage Formula Problem
I've got five cells T16, T17, T18, T19, T20.
I need to Average T16, T17, T18, in cell T20 which is formatted for
Percentage.
Cell T19 is an "NA" cell which is not counted in the percentage but
does have a value.
I have the following formula: =SUM(T16/(T16+T17+T18))
Now if entries in T16 through T18 are zeros, I get the error "DIV/0!"
in cell T20 which I need to show 100.00%.
I'd really appreciate any help on this matter.
--
Snit
|