Hello,
I'm working on a tiered commission plan with a kicker paying an additional 1% if achieved and a negative 1% kicker if other conditions are not achieved. So far, this formula meets my needs; however, I need to add a MAX condition so that it is not possible to earn more than 8% of C3. Do I start at the beginning or build it into the kickers?
thanks!
=IF(AND(OR(C2>=20,C3>=10000),C3>=12001),C3*0.05,IF(AND(OR(C2>=20,C3>=10000),C3>=8001),C3*0.04,IF(AND(OR(C2>=20,C3>=10000),C3>=4001),C3*0.03,C3*0.02)))+IF(AND(OR(C2>=20,C3>=10000),D2>0),C3*(D2*0.01),0)+IF(D2=0,C3*-0.01)+IF(F2=0,C3*-0.01)