hi,

My question is, if a sales person gets his/her pay on different slabs of
target achieved than how to get the count of achieved figure by using a
formula in Microsoft Excel worksheet.

Incentive Slabs Percentage
Nil 0-40%
$10 40-50%
$15 50-60%
$20 60%+

Target given Achieved count of cases Percentage
200 140 70%

Incentive for the same
No. of cases Achieved % Payout he/she get (in Dollars)
80 cases 40% Nil
next 20 cases <40%=50% $200 (20 cases * $10)
next 20 cases <50%=60% $300 (20 cases * $15)
next 20 cases <60%+ $400 (20 cases * $20)

Total Achievment Percentage Total Payout
180 70% $900
I want to know how can i get seperate counts for all slabs by using
formulas, I had tried harder but stumped, Please help me for the same.