I am new to macros/VBA so bear with me.

I have made two drop down menus that will influence which calculations to perform.

for simplicity,
Drop down 1 has options: "one" or "two"
Drop down 2 has options: "summer" or "fall"

So if the user chooses "one", and "summer" then after the button click, it will preform one set of calculations and display the results in a column of cells (D).
different combinations of the drop downs will calculate using other formulas.

So how can I have the code read the drop down string, then based on what it is, execute the calculations and display them in column D.


for ex.

If Dropdown 1 = one and Dropdown 2 = summer Then
D1 = A1+A2
D2 = A3/A4

ElseIf Dropdown 1 = two and Dropdown 2 = fall Then
D1 = A1-A2
D2 = A3*A4
....
ect

Thanks