|
Formula to figure bonus
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. ------------------- Any help that you can provide would be much appreciated. -- EboniDimplz ------------------------------------------------------------------------ EboniDimplz's Profile: http://www.excelforum.com/member.php...o&userid=33551 View this thread: http://www.excelforum.com/showthread...hreadid=533577 |
Formula to figure bonus
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" 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. ------------------- Any help that you can provide would be much appreciated. -- EboniDimplz ------------------------------------------------------------------------ EboniDimplz's Profile: http://www.excelforum.com/member.php...o&userid=33551 View this thread: http://www.excelforum.com/showthread...hreadid=533577 |
Formula to figure bonus
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 "RRR_News" 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 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" 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. ------------------- Any help that you can provide would be much appreciated. -- EboniDimplz ------------------------------------------------------------------------ EboniDimplz's Profile: http://www.excelforum.com/member.php...o&userid=33551 View this thread: http://www.excelforum.com/showthread...hreadid=533577 |
| All times are GMT +1. The time now is 04:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com