I have a comp plan that pays out:
1x from 0-100%
1.25X from 101%-200%
2X from 201%-250%
1x from 251%+
I've got the 0-100% correct and the 251%+ correct, but struggling with the formula for the 101-200% and 201-250%, can't figure out how to tell excel that if the commish is 225%, that the 101-200% still works.
Love some help!
Marc
Bookmarks