dividing numbers and getting percentage

[jmoney442]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I want to take a list of numbers which are already added up, and get the percentage of each one. Help.

 

[CyberTaz]

It really isn't very clear what you want to do, but I'm gonna guess that you
want to know what each number is expressed as a percentage of the sum. If
so;

Let's say the list of numbers is in cells A1:A10 with the sum in A11

In cell B1 create the formula =A1/$A$11 , format as %, then copy down to
B10 & adjust decimal display formatting as necessary. Note: The $s are
necessary to make the reference to A11 absolute ($A$11) so it doesn't change
as you copy the formula down column B.