G
Guest
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.
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.