VAT Calculation (Drop Down List)

Hi All,

I am new to this forum and I am looking for some help relating to formulas based on the drop down list in another cell. I have attached the excel file that I have.

In cell D25 I have drop down list with different types of VAT. In cell E25 I want to input formula based on selection in cell D25 that will calculate different type of VAT based on value in cell E24.

Any help is greatly appreciated.