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.

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.

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.

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

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

Cheers

Dave