Hello,

Almost done with this but I'm stumped on the last remaining formula. The
way this compensation plan will work is if reps are between 0-25% growth they
will get paid $100 per point, 26-50% $150 per point, 51-75% $200 per point.
Growth is calculated monthly vs. a monthly #. My problem is that if the rep
is at 40% they get the first 25% at $100 and the next 15% at $150. My
formula is an either or thing. The following are my formulas for 0-25%,
26-50%,51-75% respectively:

=IF(AND(D9/C90,D9/C9<1.25),((D9/C9-1))*100)/(B9/52)
=IF(AND(D9/C91.26,D9/C9<1.5),((D9/C9-1))*150)/(B9/52)
=IF(AND(D9/C91.51,D9/C9<1.75),((D9/C9-1))*200)/(B9/52)


Any suggestions?

Thanks,
Bob