I have a drop down list in my speadsheet. This same drop down is repeated maybe 40 -50 times in the worksheet. I want to apply ablity of mulitiplication to my drop down items. so that based on the drop down choose a multiplier is added.
b7....................c7......................d7.....................................e7
monthly...........1500..................1500(or c7*1)...................4500( d7+prior d7 vals)
weekly.............375....................1500(c7*4).......................3375
bi-monthly........750....................1500(c7*2).......................3750
quarterly..........4500..................1500 (c7/3).......................7500
keep in mind that b7 is selected from the drop down, c7 is manually entered, d7 is autofilled from c7 input being * or / by b7 value, and e7 is the value of d7+that of previously saved d7 values.
Please help me create formula or code that will allow me to add the required functions to the dropdown items to complete the functions required.
Thank you.
Bookmarks