IF Function

[Joeytomatoe]

I'm lost and in need of help! I'm trying to create an IF function dependant on 2 options. I can get the Y to work but not the N.

Basically I need the formula to look in column D11 if it says Y then return the sum of F11 plus G3 or if D11 says N I need it to return the value of F11

I can't seem to get it to work.

 

[eiloken]

I'm lost and in need of help! I'm trying to create an IF function dependant on 2 options. I can get the Y to work but not the N.
View attachment 104770

Basically I need the formula to look in column D11 if it says Y then return the sum of F11 plus G3 or if D11 says N I need it to return the value of F11

I can't seem to get it to work.

your formula is syntax error:

=IF(D11="Y",F11+$G$3,IF(D11="N",F11,""))

 

[Joeytomatoe]

your formula is syntax error:

=IF(D11="Y",F11+$G$3,IF(D11="N",F11,""))

Thank-you thank-you thank-you! You saved me so much frustration!!!!

 

[Elle_mostlysunny]

I'm lost and in need of help! I'm trying to create an IF function dependant on 2 options. I can get the Y to work but not the N.
View attachment 104770

Basically I need the formula to look in column D11 if it says Y then return the sum of F11 plus G3 or if D11 says N I need it to return the value of F11

I can't seem to get it to work.

If the values are just Y or N, then you can just use F11 as your FALSE, see the IF logic below