Calculations based on Drop down list option

Hello

I have a spreadsheet created for our maintenance contracts. In column C I have the contract amount i.e. £1,200.00 and in column H I have a drop down list detailing the payment terms i.e. Monthly, Quarterly or Paid In-Full. When a payment term is selected I would like in column I to automatically divide the contract amount either by 12 for Monthly, 4 for Quarterly or the whole amount for Paid In-Full.

I have attached a sample workbook which will hopefully explain it better

Many thanks

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!