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) ...
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
