Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I add a formula that totals a percentage
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I add a formula that totals a percentage
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "gia" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I add a formula that totals a percentage
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. "gia" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Try to find the difference by percentage between 2 cell totals | New Users to Excel | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
percentage formula | Excel Worksheet Functions | |||
Formula for percentage | Excel Discussion (Misc queries) | |||
Percentage formula | Excel Worksheet Functions |