Hi,
I want to run my commisssion stats in Excel. Basically if sales are between
100
200
300
400
500
I want each milestone to award 10 dollars to each person. What formula do I need to have this in a worksheet that I can run off every month.
Thanks for your help in advance!
birdoo2
Your question can best be answered by uploading an example workbook that meets the following criteria:
1. It EXACTLY duplicates the structure of your real workbook, AND
2. It contain representative but non-sensitive dummy data, AND
3. It contains a few examples of the desired results shown manually and the basic logic explained.
For your purposes, are the awards cumulative or just a flat amount for each milestone?
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
This will show 10 dollars for use 100 dollars
if there is a cap - 50 dollars in this example.
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks