I have a drop down list in my speadsheet. This same drop down i
repeated maybe 40 -50 times in the worksheet. I want to apply ablit
of mulitiplication to my drop down items. so that based on the dro
down choose a multiplier is added.

b7....................c7......................d7.. ...................................e7
monthly...........1500..................1500(o
c7*1)...................4500( d7+prior d7 vals)
weekly.............375....................1500(c7* 4).......................3375
bi-monthly........750....................1500(c7*2).. .....................3750
quarterly..........4500..................150
(c7/3).......................7500

keep in mind that b7 is selected from the drop down, c7 is manuall
entered, d7 is autofilled from c7 input being * or / by b7 value, an
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 th
required functions to the dropdown items to complete the function
required.

Thank you

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=49435