Adding

[Sarah_Lecturer]

I have the following figures:
47
125
60
121
73
203
22

These total 651

I want to display these as percentages for a report

In Excel I have

7%
19%
9%
19%
11%
31%
3%

Which equals 99% despite Excel rounding to 100%. For the purpose of the
report I need to round one of the figures sensibly so that others do not see
that this does not add up exactly to 100!

Can you help please?

thanks

Sarah xxx

 

[Mike H]

Sarah,

I should have added Ecel isn't rounding up to 100% the numbers actually add
up to that because changing the format to zero decimal places changes what
you see, not the underlying value.

Mike

 

[Cimjet]

Hi Sarah
You are ignoring de decimal, just format with one decimal and not only are
you getting 100% , you are not cheating on the figures.

47 =7.2%
125 =19.2%
60 =9.2%
121 =18.6%
73 =11.2%
203 =31.2%
22 =3.4%

Regards
Cimjet