How to sum up the rounded up percentage?
Posted on 2003-03-12
I have problem in sum up the rounding percentage in Excel report.
Here is an example:
15 14.9% (this is rounded percentage of 15 divided by 101)
21 20.8% (this is rounded percentage of 21 divided by 101)
sum 101 100.0% (Use formula to sum up the round up %, it shown 100.0% rather than 100.1%)
In the sample I got the round up percentage to 1 decimal place, but when I use formula to sum up the percentage, it shown as '100.0%' (I know this is correct for the true calculation). However, the sum up should be '100.1%' to reader as reader will not calculate herself and just refer to the round up percentage shown in report.
How can I use formula to sum up the rounded percentage so that it will give answer as '100.1%'? Please kindly help.