Drop Down list of Formulas

Hello,

I have been looking all over to a solution and cannot seem to find one. I would like to create a "drop down list" of different formulas. I have a spreadsheet that calculates earnings, but the formula is different depending on where they are hired/working. Instead of constantly copying/pasting formulas (and risk copying the wrong one), I would like to create a database of formulas. Then maybe have a drop down list that I can use to select the correct formula.

I have attached a small sample of what I would like to do.

Thank You.

-Mike

ncmay,

Thanks for your help. That seems to work. However, my actual formulas will be quite long and there will be about 12 different formulas. With your method, would I need to have all 12 formulas in the CHOOSE formula? If so, it will quickly become quite confusing.

Thanks for your help!