Yes/No formula

[funkb411]

I am needing a formula to calculate a point value for a form. For example, If in A2 you type Y then B2 will populate the number 5. If in A2 you type N then B2 will populate the number 0.

Is this possible to do in Excel and what would that formula look like?

 

[bbott]

If(a2 = "y",5,if(a2="n",0,""))

-or if you want it 0 for any value other than Y-

=IF(A2="Y",5,0)

 

[Scott Huish]

=(a2="y")*5

 

[bbott]

=(a2="y")*5

Hmmm....never thought of using a true/false like that. Just when I thought simple IF statements couldn't get any shorter.