Forum Discussion
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)
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.
Many thanks OliverScheurich that seems to work really well. You are the best
=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.
Many thanks OliverScheurich that seems to work really well. You are the best
