how to do you work out persenages
 

how do i work out the forumula for dividing

Hi Andy

not sure what you're really after but say you have the following
..........A.............B...............C
1.....................Value...........%
2.......................20
3.......................40
4.......................10
5........Total.......70

and you want to determine what percentage of the Total each value is (ie the
formula for column C)
then in C2
=B2/$B$5
and then fill down (move mouse over bottom right hand corner of the cell and
when you see a + double click)
(delete C5 if required)
now select C2 through C4 and click on the % icon on the formatting toolbar

if you don't want to use the % icon on the formatting toolbar the formula
you need in C2 is
=B2/$B$5*100
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"andy" wrote in message
...
how do i work out the forumula for dividing