| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exact percentage of each cell
how do i get the exact percentage of each cell in a row of numbers from the
total row amount |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact percentage of each cell
Exact percentage? Can you post a sample of your data as it is now, and
describe what you would like to see? Regards, Ryan-- -- RyGuy "lea" wrote: how do i get the exact percentage of each cell in a row of numbers from the total row amount |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact percentage of each cell
If your data is in A1:A10 and the SUM is in A11 enter the following in B1
=A1/$A$11 Right click on B1, select percentage. Now drag it down. Is this what you want? "lea" wrote in message ... how do i get the exact percentage of each cell in a row of numbers from the total row amount |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact percentage of each cell
Thanks, that was great
"Gaurav" wrote: If your data is in A1:A10 and the SUM is in A11 enter the following in B1 =A1/$A$11 Right click on B1, select percentage. Now drag it down. Is this what you want? "lea" wrote in message ... how do i get the exact percentage of each cell in a row of numbers from the total row amount |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact percentage of each cell
You're welcome.
"lea" wrote in message ... Thanks, that was great "Gaurav" wrote: If your data is in A1:A10 and the SUM is in A11 enter the following in B1 =A1/$A$11 Right click on B1, select percentage. Now drag it down. Is this what you want? "lea" wrote in message ... how do i get the exact percentage of each cell in a row of numbers from the total row amount |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to paste exact value into another cell? | Excel Worksheet Functions | |||
| OR(EXACT(Cell; Range)) does not work properly | Excel Worksheet Functions | |||
| Formula for cell=exact(left...&2) | Excel Discussion (Misc queries) | |||
| Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
| Extracting an exact phrase from a Cell | Excel Discussion (Misc queries) | |||
Linear Mode
