IF Statement from a Drop Down List

0

Hello, I am working on a budget spreadsheet and have a formula question for you.  Basically its an IF statement based on a drop down menu.  If the section from the drop down menu is "proposed" (S4), "declined" (S12) or "cancelled" (S13) I want the value of the cell to be "0" but if it's anything else (7 options) I want the value of the cell to be the value of Cell F7.

I am trying to use the formula below but am getting the "too many arguments" error.  Please help!

=IF(K7=S4,0,F7,IF(K7=S12,0,F7,IF(K7=S13,0,F7))))))

Answer
Discuss

Answers

0
=IF(AND(K7<>"proposed",K7<>"declined",K7<>"cancelled"),F7,0)

Just noticed you used cell references instead of hard-coding the text, this formula works the same regardless of how you do it.

Discuss
0

Use this formula:

=if(or(k=s4,k7=s12,k7=s13),0,k7)
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login