Merge 2 formulas require ASAP

Can someone help me merge the two formulas together please and I also need it to work out the following way

So basically

If A2 = Monthly & B2 = Active.... do the following (If B2 says anything other than Active it must not return a value or can return 0)
=IF(H2<20.99,H2*12.5%,IF(H2<30.49,Sheet2!$D$4+((H2-Sheet2!$D$3)*12.5%),IF(H2<39.59,Sheet2!$F$4+((H2-Sheet2!$F$3)*12.5%),IF(H2>=39.59,Sheet2!$H$4+((H2-Sheet2!$H$3)*12.5%),0))))

If A2 = Yearly & B2 = Active.. do the following (If B2 says anything other than Active it must not return a value or can return 0)
=IF(H2<149.99,H2*2.5%,IF(H2<299.99,Sheet2!$E$4+((H2-Sheet2!$E$3)*2.5%),IF(H2<399.99,Sheet2!$E$4+((H2-Sheet2!$E$3)*2.5%),IF(H2>=399.99,Sheet2!$E$4+((H2-Sheet2!$E$3)*2.5%),0))))

I need to merge the following formula together and paste it into K2

Sheet attached

There are times when it's "OK" to split calculations into multiple columns..
And sometimes it's even preferred.

If you already have the monthly and yearly calcs in Sheet1 G2 and H2..
I would just do this in Sheet1 I2
=IF(B2="Active",IF(A2="Monthly",G2,H2),0)

Cheers the ones that appear as false how can i get them to appear as 0 in the below formula?


=IF(AND(A16="Monthly",B16="Active"),IF(F16<20.99,F16*12.5%,IF(F16<30.49,Sheet2!$D$4+((F16-Sheet2!$D$3)*12.5%),IF(F16<39.59,Sheet2!$F$4+((F16-Sheet2!$F$3)*12.5%),IF(F16>=39.59,Sheet2!$H$4+((F16-Sheet2!$H$3)*12.5%),0)))),IF(AND(A16="Yearly",B16="Active"),IF(F16<199.99,F16*12.5%,IF(F16<299.99,Sheet2!$E$4+((F16-Sheet2!$E$3)*12.5%),IF(F16<399.99,Sheet2!$G$4+((F16-Sheet2!$G$3)*12.5%),IF(F16>=399.99,Sheet2!$I$4+((F16-Sheet2!$I$3)*12.5%)