SOLVED

# Drop Down Menu selection to trigger different calculations on gross salary

Copper Contributor

# Drop Down Menu selection to trigger different calculations on gross salary

I am having problems with this

I have a drop down menu in cell B2 with the following options;

No Plan       0

Plan 1         =IF(A2>22015,A2*0.09,0)

Plan 2        =IF(A1>27295,A1*0.09,0)

Plan 4         =IF(A1>27660,A1*0.09,0)

Plan 5          =IF(A1>25000,A1*0.09,0)

I want a formula to be performed for the annual loan repayments based on the users selection in B2. The formula will be performed on the gross salary in A2 but is dependent on the value in A2 being over a certain threshold if it is below the result will be returned as 0- see calculations next to drop down options above.

2 Replies

# Re: Drop Down Menu selection to trigger different calculations on gross salary

=IF(AND(B2="Plan 1",A2>22015),A2*0.09,

IF(AND(B2="Plan 2",A2>27295),A2*0.09,

IF(AND(B2="Plan 4",A2>27660),A2*0.09,

IF(AND(B2="Plan 5",A2>25000),A2*0.09,

You can try this formula in cell C2.

best response confirmed by martin960 (Copper Contributor)
Solution

# Re: Drop Down Menu selection to trigger different calculations on gross salary

Many thanks @OliverScheurich that seems to work really well. You are the best

1 best response

Accepted Solutions
best response confirmed by martin960 (Copper Contributor)
Solution

# Re: Drop Down Menu selection to trigger different calculations on gross salary

Many thanks @OliverScheurich that seems to work really well. You are the best