T
The Hit man
I have seen similiar examples but not that were not using exact matches to
retrieve data. This seems simple and maybe I am over thinking but I have been
unable to crack this nut. I have a table where the first tier sales runs
between 0 and 20k and awards 1K commission. I want to be able to enter the
salse result for various team members and obtain the correct commission
amount based on their sales for the period. How should I complete the
commission formula for this process?
Sales Value Start Sales Value Stop Commission
$0 $20,000 $1,000.00
$20,001 $25,000 $1,100.00
$25,001 $30,000 $1,200.00
$30,001 $35,000 $1,300.00
Sales Commission
$5,000 $0
$25,001 $0
$32,000 $0
retrieve data. This seems simple and maybe I am over thinking but I have been
unable to crack this nut. I have a table where the first tier sales runs
between 0 and 20k and awards 1K commission. I want to be able to enter the
salse result for various team members and obtain the correct commission
amount based on their sales for the period. How should I complete the
commission formula for this process?
Sales Value Start Sales Value Stop Commission
$0 $20,000 $1,000.00
$20,001 $25,000 $1,100.00
$25,001 $30,000 $1,200.00
$30,001 $35,000 $1,300.00
Sales Commission
$5,000 $0
$25,001 $0
$32,000 $0