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

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

"Mike H" wrote:

Sarah,

Assuming your numbers are in a1 down put this in b1 and drag down
=A1/SUM($A$1:$A$7)

47 7.22%
125 19.20%
60 9.22%
121 18.59%
73 11.21%
203 31.18%
22 3.38%
and you will get this

If you want it exactly as in your post format to 0 decimal places to get this

47 7%
125 19%
60 9%
121 19%
73 11%
203 31%
22 3%


Mike
"Sarah_Lecturer" wrote:

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

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

"Sarah_Lecturer" wrote in message
...
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