Calculated value to a table

J

JJ

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?
 
T

T. Valko

=fat * 9 / total calories

A2 = total calories = 100
B2 = fat = 10g

=B2*9/A2

format as %

90% of the calories come from fat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need an expression that's larger than my skill 5
making cells change relative to each other? cant figure out help plz 7
Milenko Kindl and America's Worst French Fries 3
How to transfer a sum from one spredsheet to another 2
Drop down menu 1
making cells change relative to each other, cant figure out 1
making cells change relative to each other? cant figure it out 1
Recalculating problem. 3

Top