[Webinar] Streamline your web hosting managementRegister Today

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 529

# How to sum up the rounded up percentage?

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)
10          9.9%
55          54.5%
---         -----
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.
0
mikepsps125
1 Solution

if your formula is = ROUND(15/101,3) it will return 14.9%with no further decimals. The 14.9% you have above is actually 14.85% as excel has truncated not forgotten the remainingd decimals. The ROUND formula removes the decimals

So change your perectage calcs to (x/101,3). The total of these will equal 100.1%.

Cheers

Dave

0

Author Commented:
Thanks for help.

Regards,
Mike
0

## Featured Post

Tackle projects and never again get stuck behind a technical roadblock.