[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

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.
1 Solution
Dave BrettVice President - Business EvaluationCommented:
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%.



mikepsps125Author Commented:
Thanks for help.


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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