IF function returns the "value if false" whether input is true or false

Question

Hi,

I'm trying to use the IF function for the first time but the function always returns the second value, the "value if false," regardless of whether the input is true or false. When I hover my cursor over my formula Excel says that 0 is the "value if true" and 10 is the "value if false," but when I actually use the formula that's not what I get - only tens even though I'm not inputting only falses.

What am I doing wrong?

Thank you.

Answer 1

Column C does not contain "Yes" (or "No") but TRUE (or FALSE). So the formula in D2 should be

=IF(C2, 0, 10)

then fill down, or

=IF(C2:C100, 0, 10)

to populate D2:D100 in one go.

You might also use

=10*NOT(C2:C100)

Answer 2

Perfect, thank you!