Excel - Is it possible to create a price calculator that has varying prices for different contract terms?

I am wanting to create a price calculator using drop downs where one of the drop downs is contract term. The price per service varies depending on the length of the contract, so when the drop down for a 24 month term is selected, I only want the pricing for that particular service on a 24 month term displayed. If the contract term drop down changes to 36 month term, I want the 36 month pricing to be displayed etc.

Also, some of the services have two variable fields that combine to make up the pricing. E.g. a broadband connection - there is both the speed of the connection & the data allowance associated with that connection.

I am not sure what formulas to use or if it is even possible to do what I want.

hopefully that all makes sense. let me know if any further information is required.

Recent Questions...