Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage problem | Excel Discussion (Misc queries) | |||
Percentage problem | Excel Discussion (Misc queries) | |||
formula percentage problem | New Users to Excel | |||
Help Please with a percentage problem | New Users to Excel | |||
Percentage problem | Excel Discussion (Misc queries) |