| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate Percent in a Column
Oops.. I didn't notice there was a total field. My bad...
"Mike H" wrote: Assuming weights in column B and total in B4 =B1/$B$4 drag down and format as % Mike "Ruko" wrote: I have a recipe that contains a column of 24 different items with their weights. I want to calculate the percentages of each of the 24 items and place the result in the next column. How do I do it? Example: Celery 5.0 Carrots 4.0 Oatmeal 10.0 Total 19.0 In the column next to the weights I want percent. Thanks ruko -- Ruko |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate percent | Excel Discussion (Misc queries) | |||
| Calculate percent of a total within a cell | Excel Discussion (Misc queries) | |||
| formula to calculate a specific percent of a column of different p | Excel Worksheet Functions | |||
| How to calculate and then show up as a percent? | Excel Worksheet Functions | |||
| calculate percent increase | Excel Discussion (Misc queries) | |||
Hybrid Mode
