#Value! Error

[scottmay67]

I am constructing a formula and it's not outputting what I would like. My excel spread sheet is as follows

A B C D E F

Day Food Calories Fat Calories Fat
Consumed Grams From Fat Percentage

Wednesday Apple 65 0 #VALUE!
Turkey Sandwich 220 3 27 0.122727273
Granola Bar 150 9 81 0.54


In order to calculate the calories from fat, the problem said to multiply by 9 Fat Grams, and I got this function =IF(D10<>0,D10*9,""). The reason I did "" for the false statement is because I want it blank.

For the Fat Percentage it says that it is calculated by dividing the Calories from Fat by the Calories. I then got this formula =IF(E10<>0,E10/C10,""). I want to get this as a blank but it responds with a #VALUE!

Can someone please help me with my problem. Thanks.

[robert111]

check if D10 contains text or a number by trying to format it to 2 decimal places for a start

[scottmay67]

The number for D10 is 0, and doesn't have any values after 0.

Can someone please help me with this please.

[Dunc3142]

We can see it better if you zip an Excel file with what you are trying to do.