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))))))
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
IF Statement from a Drop Down List
0
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.
0
Use this formula:
=if(or(k=s4,k7=s12,k7=s13),0,k7)