I am Excel challenged and looking for assistance in creating a spreadsheet that provides calculation for the following commission plan:
1.0% on the first 45% of goal (say goal is $3,000,000), 1.5% on the second 45% of goal, and 2% above 90% of goal.
Your help will be greatly appreciated!
C.
Bookmarks