Hello there, wondering if anyone could help with this:

I have set up a sales forecasting spreadsheet. Cell A1 contains a drop down
list similar to this:

M1 - Start Trial - 10%
M2 - Finsh Trial - 20%
M3 - Provide Quote - 30%

Cell B1 contains a value e.g. $1000

I was wondering if it would be possible to link the users selection in the
drop down list to a calculation on the value in cell B1.

For example:

A1 contains "M1 - Start Trial - 10%" and cell B1 contains the value $1000.
When the user selects "M1 - Start Trial - 10%" from the drop down list, I
need the spreadsheet to perform a calculation and add B1*0.10 into cell C1.

Then, at a later date, when the user selects the next milestone i.e. "M2 -
Finish Trial - 20%" from the drop down list, I need the spreadsheet to
perform a calculation on the value in B1 (B1*0.20) and change the value in
cell C1.

Is this possible?

Thanks
Hywel