Dropbox menu to set formulas

[AcerExcel]

Hi there,

This is probably a very simple problem but I suppose i'm not sure what I'm asking and so have had troubles finding it through google.



What I would like to do is create a drop down menu that will then set formulas in accordance to the selection.

I have several metrics I use to evaluate performance, CPM, CPV, CPC, etc. What I want to do is make it very simple by selecting CPM for example and then it will set up that row with all the formulas to work out CPM and other relevant metrics related to CPM.

Hypothetically it would work by having the drop box menu in B1 then information would be in cells B2:B7 and then a formula in B8 using the relevant information in B2:B7 to calculate the CPM (or whichever metric has been selected).

Hopefully this is clearly explained. Any help would be greatly appreciated.

Many thanks,

Rich