Formula to figure bonus

[EboniDimplz]

Can anyone help me out on the steps to do the following:
---------------------------
A bonus formula that addresses the following requirements:
A sales person needs to sell more than 260 units per quarter to qualif
for a bonus.

Create a cell that is labeled "Bonus Quantity" and put the value 260 i
it.

Reference this cell in the computation. Adjust the data so that a
least two but not all salespersons earn a bonus.

The bonus is calculated at the following rate:

$15 per unit for each unit sold over 260

PLUS an additional 5% of this amount (units over 260 x $15) will b
added for each year of service that the sales person has attained.

The amount should be displayed in a cell labeled “Bonus Total for th
Quarter.”

Salespersons who sold 260 units or fewer should get a zero in the bonu
column.

 

[RRR_News]

EboniDimplz,
This set-up will show either you made the bonus and the amt, or not. Try the
following:

A1 B1
Bonus Qty 260
A2 B2
% by Yrs .05
A3 B3
Bonus/Unit $15.00

For the Title Row

A5=Name
B5=Yrs of Service
C5=Units Sold
D5=Bonus total for Qtr


So if you starting in A7 with the employee's name, in the D6 cell put the
following formula. and fill down.
=IF(C6-$B$1<0,0,SUM(((C6-$B$1)*$B$3),(C6-$B$1)*$B$3*B6*$B$2))


--

Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"EboniDimplz" <[email protected]>
wrote in message

Can anyone help me out on the steps to do the following:
---------------------------
A bonus formula that addresses the following requirements:
A sales person needs to sell more than 260 units per quarter to qualify
for a bonus.

Create a cell that is labeled "Bonus Quantity" and put the value 260 in
it.

Reference this cell in the computation. Adjust the data so that at
least two but not all salespersons earn a bonus.

The bonus is calculated at the following rate:

$15 per unit for each unit sold over 260

PLUS an additional 5% of this amount (units over 260 x $15) will be
added for each year of service that the sales person has attained.

The amount should be displayed in a cell labeled “Bonus Total for the
Quarter.”

Salespersons who sold 260 units or fewer should get a zero in the bonus
column.

 

[Guest]

"Adjust the data so that at

least two but not all salespersons earn a bonus"

what criteria exclude salepeople from getting a bonus.

 

[RRR_News]

Correction of Formula:

=IF(C6-$B$1<1,0,SUM(((C6-$B$1)*$B$3),(C6-$B$1)*$B$3*B6*$B$2))

--

Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


EboniDimplz,
This set-up will show either you made the bonus and the amt, or not. Try the
following:

A1 B1
Bonus Qty 260
A2 B2
% by Yrs .05
A3 B3
Bonus/Unit $15.00

For the Title Row

A5=Name
B5=Yrs of Service
C5=Units Sold
D5=Bonus total for Qtr


So if you starting in A7 with the employee's name, in the D6 cell put the
following formula. and fill down.
=IF(C6-$B$1<0,0,SUM(((C6-$B$1)*$B$3),(C6-$B$1)*$B$3*B6*$B$2))


--

Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"EboniDimplz" <[email protected]>
wrote in message

Can anyone help me out on the steps to do the following:
---------------------------
A bonus formula that addresses the following requirements:
A sales person needs to sell more than 260 units per quarter to qualify
for a bonus.

Create a cell that is labeled "Bonus Quantity" and put the value 260 in
it.

Reference this cell in the computation. Adjust the data so that at
least two but not all salespersons earn a bonus.

The bonus is calculated at the following rate:

$15 per unit for each unit sold over 260

PLUS an additional 5% of this amount (units over 260 x $15) will be
added for each year of service that the sales person has attained.

The amount should be displayed in a cell labeled “Bonus Total for the
Quarter.”

Salespersons who sold 260 units or fewer should get a zero in the bonus
column.