bonus

Hi all, I am looking to create a formula that will look up a list of employees and check to see if they have had any sickness incidents within a month. This will then show eligible or ineligible for their name. I have tried various IF and VLOOKUP methods, and that is where my knowledge ends...

I'm having a brain fart. How do I write a formula that calculates the percentage of bonus payout based on the picture/table below? If the quota sold is less than 96 widgets, there is no bonus If you reach 96 widgets you immediately receive 50% of your bonus. Prorate the bonus with a linear...

Hoping someone might have some thoughts on optimizing the code below. I am inserting 5 rows each time a new employee is found. Then adding the text for the pay category. I have done some research and was wondering if "Resize" may be a viable option. Thanks, Bob X = 2 Do Until Cells(X...

I have 4 =IF(AND(SUM formulas that all work individually, but I would like to get them all to work in one cell. Can this be done? Here are the formulas: =IF(AND(SUM(D3:L3)>9,(SUM(D3:L3)<14),SUM(D3:E3)>0,SUM(F3:G3)>0),"$50","$0") =IF(AND(SUM(D3:L3)>14,SUM(D3:L3)>0,SUM(F3:G3)>0),"$75","$0")...

Trying to setup a spreadsheet to do this but here's the grid below. Bonuses are ONLY given on the amount between the threshold. For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production. You...

Dear All, Can you please help me to transpose data. I have three columns "Emp_ID, Compensation Plan and Amount. I want Compensation Plan to be transposed to Basic salary, HRA, Bonus and Commuting Allowance by Columns. I have 4000 employees list which has more than 18k rows. Please help...

Dear Mr. Excel, Hope this mail finds you in good health. I have a question, and would appreciate it if you could answer it ASAP. Ex: I have a bonus pool of 150,000 to be distributed among 5 employees on criteria of grade, department, annual evaluation and their date of joining (pro rata)...

Hi All, I need a formula to work out payments based on performance, the challenge I'm facing is that there are various scales of payemnt depantdant on the formula. and I just cannot figure it out. So if A1 is greater than F1 but less than F2, I need it to show a bonus amount in H5. But then it...

Have a problem getting the formula down. I've tried =MIN(January!C20*0.25*0.15) my salary field my % field =MIN(0.15,(January!E3+February!E3+March!E3)/3) The salaries vary. So let's say on a 75,000 dollar salary, the quarterly bonus can pay out no more than 15% or no more than 2,812.50. But...

Hello, I need to build a formula that can tell me that if my salary rank is 2 then i get 2% bonus, but if I work at night I get 1% extra bonus. The way I know i work at night is because there is a column that says N --> Salary Rank Salary Work At Night 2% 200 N math...

Hi I want to provide text result based on students score but also I want to modify the score and add bonus based on the score and put the new result in "new score" column. The conditions are the following If the score is >20 = very good ( they get a 5% performance bonus) If the score is 16-20 =...

Hi there, I need to calculate the bonus to be received by an employee who has generated total sales of for example $180.000. After all the calculations he must take $6.800. The bonus scale is 8% for amounts between 120001-130000, plus 10% for amounts between 130001-140000 plus 11% for...

I am looking for help figuring out a formula that will calculate the following: <tbody> Range Bonus (per million) $7 Million - $16 Million $5,000 $17 Million - $27 Million $2,500 $28 Million + $1,000 </tbody> Thank you!

I've putted this Formula ="2. Festival Bonus : "&"(26120*2) "&TEXT(SUM(26120,26120),"#0,#00"&"/00") and returns '#VALUE!'

Hello All :biggrin: I have a spreadsheet I use to pay our employees on a 4-weekly basis. We also include a production bonus, which we're modifying to a performance based one. My head is a little pickled!... I have a cell with a "Bonus Pot" for the month - this is the ££ figure I have to share...

Hi everyone, Happy Friday! I'm trying to work out a couple of things regarding leveraged payouts, i.e. if I hit 120% of X production, I get paid out 140% of my X dollar payout. Scenario: performance score of $1M. My bonus payout is targeted at $50,000 but the production of $1M represents a...

Hi there, I am wondering if someone can help me figure out how to format this formula. Let's say I open up a CD for 5 years (60 months). If I keep the money in there for at least 4 months without breaking it I will get a $1000 bonus and the APY is 3%. How do I calculate the effective annual...

Cheers Excel Lovers, I have a problem with which formula to use, The problem is I have a sales data and I am giving out bonus based on the performance. The data is simple, <tbody> Sales Peformance range A B Bonus $0 $250 $50 $251 $500 $100 $501 $750 $150 $751 $1000 $200 </tbody>...

I need help showing only columns based on criteria. I have a spreadsheet with Q1, Q2, Q3 and Q4 data. If I type "Q1" into a specific cell (in this case cell C2 which is shaded) I want all of the cells containing Q1 at the top to appear and all of the cells that contain Q2, Q3 and Q4 to be...

Hi guys, I am trying to workout a bonus formula, but got stuck on, I want to see in the formula column, if I change the number in red (100), the fomula would show for the range the bonus, as for example, 45 - 36 = 9 then max payout is 450, but i want to see inbetween if there is for example...