a number as a percentage out of a total
 

Hi
can anyone help me; how do I convert absolute figures into percentages of a
total? example;
a 236
b 556
c 912
sum 1704
if 1704 is the total, how then do I figure out how many percentage out of
1704 b (556) is?

="part"/"whole" and format as %
=a1/a4
=556/1704

"solskinn" wrote in message
...
Hi
can anyone help me; how do I convert absolute figures into percentages of
a
total? example;
a 236
b 556
c 912
sum 1704
if 1704 is the total, how then do I figure out how many percentage out of
1704 b (556) is?

=556/1704

format as percentage


Regards,

Peo Sjoblom

"solskinn" wrote:

Hi
can anyone help me; how do I convert absolute figures into percentages of a
total? example;
a 236
b 556
c 912
sum 1704
if 1704 is the total, how then do I figure out how many percentage out of
1704 b (556) is?

In B1 enter A1/$A$4 and drag/copy down to B3

A1 236 =A1/$A$4 returns 13.85%
A2 556 =A2/$A$4 returns 32.63%
A3 912 =A3/$A$4 returns 53.52%
A4 1704

Note the $ signs used to make A4 "absolute".

Gord Dibben Excel MVP

On Wed, 8 Dec 2004 08:23:03 -0800, "solskinn"
wrote:

Hi
can anyone help me; how do I convert absolute figures into percentages of a
total? example;
a 236
b 556
c 912
sum 1704
if 1704 is the total, how then do I figure out how many percentage out of
1704 b (556) is?