how do I add a formula that totals a percentage

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

Guest

I am a novice excel user. I was given a project that includes adding a cell
for a percentage of a total. The project is small, 6 cells with 2 digit
numbers, I need to pick one cell and find the percentage it is of the total
cells. I've looked up percentrank, downloaded an addon pack for data
analysis...I'm lost.

No where can I find an example of the formula I need.

Don't laugh.

:)

Thanks much in advance!

gia
 
One example ..

Assuming the 6 source cells are A2:A7,
with the total computed in A8: =SUM(A2:A7)

You could put in B2: =A2/$A$8
Format B2 as percentage to taste
(via Format > Cells > Number tab)
then just copy B2 down to B8

B2:B7 will return the corresponding percentages that you need
 
If I understand correctly you have six cells containing values (say A1:A6)
and you want to get the percentage of any one of these values of the total
of A1:A6
If so,
=A1/SUM($A$1:$A$6) in B1
will give the percentage of A1, drag that down to B6 and format the cells in
B1:B6 as percentages,
Regards,
Alan.
 
Back
Top