software

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 quot;Bonus Quantityquot; 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.
-------------------

Any help that you can provide would be much appreciated.--
EboniDimplz
------------------------------------------------------------------------
EboniDimplz's Profile: www.excelforum.com/member.php...oamp;userid=33551
View this thread: www.excelforum.com/showthread...hreadid=533577EboniDimplz,
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 QtrSo if you starting in A7 with the employee's name, in the D6 cell put the
following formula. and fill down.
=IF(C6-$B$1lt;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) lt;message rulegt;
lt;lt;Previous Text Snipped to Save Bandwidth When Appropriategt;gt;quot;EboniDimplzquot; gt;
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 quot;Bonus Quantityquot; 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.
-------------------

Any help that you can provide would be much appreciated.--
EboniDimplz
------------------------------------------------------------------------
EboniDimplz's Profile:
www.excelforum.com/member.php...oamp;userid=33551
View this thread: www.excelforum.com/showthread...hreadid=533577quot;Adjust the data so that at
gt; least two but not all salespersons earn a bonusquot;

what criteria exclude salepeople from getting a bonus.
--
paul

remove nospam for email addy!
quot;EboniDimplzquot; wrote:

gt;
gt; Can anyone help me out on the steps to do the following:
gt; ---------------------------
gt; A bonus formula that addresses the following requirements:
gt; A sales person needs to sell more than 260 units per quarter to qualify
gt; for a bonus.
gt;
gt; Create a cell that is labeled quot;Bonus Quantityquot; and put the value 260 in
gt; it.
gt;
gt; Reference this cell in the computation. Adjust the data so that at
gt; least two but not all salespersons earn a bonus.
gt;
gt; The bonus is calculated at the following rate:
gt;
gt; $15 per unit for each unit sold over 260
gt;
gt; PLUS an additional 5% of this amount (units over 260 x $15) will be
gt; added for each year of service that the sales person has attained.
gt;
gt; The amount should be displayed in a cell labeled “Bonus Total for the
gt; Quarter.”
gt;
gt; Salespersons who sold 260 units or fewer should get a zero in the bonus
gt; column.
gt; -------------------
gt;
gt; Any help that you can provide would be much appreciated.
gt;
gt;
gt; --
gt; EboniDimplz
gt; ------------------------------------------------------------------------
gt; EboniDimplz's Profile: www.excelforum.com/member.php...oamp;userid=33551
gt; View this thread: www.excelforum.com/showthread...hreadid=533577
gt;
gt;

Correction of Formula:

=IF(C6-$B$1lt;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) lt;message rulegt;
lt;lt;Previous Text Snipped to Save Bandwidth When Appropriategt;gt;quot;RRR_Newsquot; gt; wrote in message
...
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 QtrSo if you starting in A7 with the employee's name, in the D6 cell put the
following formula. and fill down.
=IF(C6-$B$1lt;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) lt;message rulegt;
lt;lt;Previous Text Snipped to Save Bandwidth When Appropriategt;gt;quot;EboniDimplzquot; gt;
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 quot;Bonus Quantityquot; 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.
-------------------

Any help that you can provide would be much appreciated.--
EboniDimplz
------------------------------------------------------------------------
EboniDimplz's Profile:
www.excelforum.com/member.php...oamp;userid=33551
View this thread: www.excelforum.com/showthread...hreadid=533577