How to sum up the rounded up percentage?

Posted on 2003-03-12
Medium Priority
Last Modified: 2006-11-17
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.
Question by:mikepsps125
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 50

Accepted Solution

Dave Brett earned 80 total points
ID: 8125910
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%.




Author Comment

ID: 8125975
Thanks for help.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question