drop down with formula

[stephme55]

Hello. I have four scenarios that I want to put in a dropdown box and I want a formula to change based off of the value in the dropdown. How can I do this?

[lcartwright]

Can you make a dynamic list for the dropdown box, then make the formula with an "=IF" statement?

[shg]

=if(dropdown=1, thisFormula, if(dropdown=2, thatFormula, someOtherFormula))