Formula Problem
 

I have to work out the following problem and I can't figure out how.

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.

Formula Problem
 

In A1 thru A5, enter:

261
260
$15
12
5%

where A1 contains the units sold
where A2 contains 260 the minimum needed for a bonus
where A3 contains $15 the bonus
where A4 contains 12 the years of service
where A5 contains %5 the addtional percent bonus

In another cell enter:

=(1+A4*A5)*MAX((A1-A2)*A3,0)

--
Gary''s Student - gsnu200739


"Excellerated" wrote:

I have to work out the following problem and I can't figure out how.

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.