Hi,

I need some assistance with the following.

I have a spreadsheet which i use as a price list.

Within the price list is a selling price for maintenance which is a % of the license cost.

There is 3 different types of maintenance, each being a percentage.

I need to, with data validation have the ability to pick the maintenance option and it should automaticly populate the tab with the correct amount by taking the selling price and multiplying it by the %.

No matter which one of the 3 maintenance options I pick it should automaticly change the value

Percentage
Gold 18%
Platinum 25%
Silver 16%

So, If I select silver for example, C6 has to automaticly calculate 16% * A9 and populate this in C9. Or, if I pick Gold from the dropdown it has to multiply A9 * 18%

Hope this helpsCopy of Book1.xlsx