a number as a percentage out of a total

[Guest]

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?

 

[CarlosAntenna]

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

 

[Guest]

=556/1704

format as percentage


Regards,

Peo Sjoblom

 

[Gord Dibben]

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