a number as a percentage out of a total

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top