Forum Discussion
If statement based on drop down
Hello,
I'm making a brew sheet and am stuck. I'm decent with excel, but not this advanced.
In the sheet, I'm working on the formula for cell F11. The formula is complete, with the except...
It looks like that's what I'm going for, however when I put it in the forumla it just says "#NAME?" in D11 for the output. It's not that I want to multiple the whole equation by that, it's that I want the ".75" in the equation to be either .75, .95, or 1.25 based on high medium low, and if someone selects no, then the entire equation is divided by 2.
also, I don't know if I set you up with my title "If statement.."...I have no preference for if statements if there's better ways to do this.
If you are interested, you may try the following formula
=((((((182.4601 * F2 -775.6821) * F2 +1262.7794) * F2 -669.5622) *10) *0.75)/ 50 )* B4 * (0.5 + N(D4<>"Yes")*0.5) * INDEX({0.75;0.9;1.25},MATCH(D3,{"Low";"Medium";"High"},0),1)
Note: If you do not select anything in D3, it will come out #N/A.