SOLVED

Drop Down Menu selection to trigger different calculations on gross salary

Copper Contributor

 

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)

Postgraduate Loan   =IF(A1>21000,A1*0.06,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. 

 

martin960_0-1693914896346.pngmartin960_1-1693914924164.png

 

2 Replies

@martin960 

=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,

IF(AND(B2="Postgraduate Loan",A2>21000),A2*0.06,0)))))

 

You can try this formula in cell C2.

best response confirmed by martin960 (Copper Contributor)
Solution

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

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

View solution in original post