Percentage formula

[Robert]

I need help with writing a percentage formula. Number in
the A column to total at bottom. and Percentage in B
column. The number in A1 should be % of total A column in
B1.

 

[Frank Kabel]

Hi Robert
if your total value for column A is stored in cell A10 enter the
following in B1
=A1/$A$10
format the cell as percentage (goto 'Format - Cells')
copy this formula down for all rows

HTH
Frank

 

[Max]

Assume the numbers are in A2:A5 with total in A6

Try in B2: =A2/$A$6

Format B2 as percentage

Copy B2 down to B6

 

[Ozzie]

This seems too easy..

if your total for a1 thru a9 is in a10, then in b2 enter

=+A1/$A$10, then Format b2 as a percentage (right click on
box = click on format), then then copy down.


(FYI - The $$ lock the denominator.)

HTH

 

[Paul]

You don't need the + sign in your formula.

This seems too easy..

if your total for a1 thru a9 is in a10, then in b2 enter

=+A1/$A$10, then Format b2 as a percentage (right click on
box = click on format), then then copy down.


(FYI - The $$ lock the denominator.)

HTH