Reply to thread

Message

[QUOTE="aarif, post: 3620974"]
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.
[/QUOTE]

Verification