atxmichael
New Member
- Joined
- Aug 6, 2004
- Messages
- 8
I'm developing a sales/commission tracking log for my company, the problem I have run into is this:
The reps work on a points system
0 to 29pts = $0
30pts = $300
31-40pts = $10 per point
41-50pts = $15 per point
Greater than 50pts = $20 per point
I need formula that will calulate a dollar amount based on the number points.
EX: rep1 has 47pts his Bonus would be $505 (30=$300, 10@$10=$100 7@$15=105)
I know the basics of excel but can't figure out where to start on this. Any help would be greatly appreciated! thanks again.
The reps work on a points system
0 to 29pts = $0
30pts = $300
31-40pts = $10 per point
41-50pts = $15 per point
Greater than 50pts = $20 per point
I need formula that will calulate a dollar amount based on the number points.
EX: rep1 has 47pts his Bonus would be $505 (30=$300, 10@$10=$100 7@$15=105)
I know the basics of excel but can't figure out where to start on this. Any help would be greatly appreciated! thanks again.