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

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