Kelly frank
New Member
- Joined
- Sep 28, 2005
- Messages
- 1
I need some help. I have to desing a spreadsheet for sales commissions that is based on percentage of budget reached. For example, if the salesperson reached 93% or less of budget, his commission percentage is 13%, if he reaches 94%-103% of budget his percentage is 15%, if he reacehs over 103% of budget his percentage is 17%. I have a spreadsheet for each saleperson that shows billing, budget and then calculates the percent to budget. How do I get the vlookup forumla set up to automatically enter the correct percentage based on the percent of budget reached?
ANy info would be great.
Thanks!
ANy info would be great.
Thanks!