| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated value to a table
How would I set this calculated value up? Fat contains nine calories per
gram. I want to calculate the calories from fat for each food item. The percentage of fat is calculated by dividing the calories from fat by the total number of calories. What would this formula look like? -- jj |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculated value to a table
=fat * 9 / total calories
A2 = total calories = 100 B2 = fat = 10g =B2*9/A2 format as % 90% of the calories come from fat -- Biff Microsoft Excel MVP "JJ" wrote in message ... How would I set this calculated value up? Fat contains nine calories per gram. I want to calculate the calories from fat for each food item. The percentage of fat is calculated by dividing the calories from fat by the total number of calories. What would this formula look like? -- jj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| calculated field in a pivot table? | Excel Discussion (Misc queries) | |||
| % of calculated field in pivot table | Excel Worksheet Functions | |||
Linear Mode
