# bonus

1. ### Inserting Multiple Rows In Very Large Worksheet

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...
2. ### IFANDSUM Questions

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")...
3. ### Tiered bonus structure

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...
4. ### VBA Code for transpose for Large Data Set

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...
5. ### Bonus Calculation - Pro Rata

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)...
6. ### Long greater than, less than formula

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...
7. ### Quarterly Bonus Calculation with a cap - Help needed

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...
8. ### IF and AND formula

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...
9. ### text results based on score and also changing the score

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 =...
10. ### Function or VBA for bonus scale

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...
11. ### Formula that calculates a tiered bonus

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!
12. ### #VALUE! Error

I've putted this Formula ="2. Festival Bonus : "&"(26120*2) "&TEXT(SUM(26120,26120),"#0,#00"&"/00") and returns '#VALUE!'
13. ### Formula Help: Sharing a bonus payment across multiple employees

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...
14. ### Leverage Payouts on Percentages

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...
15. ### Effective Interest Rate

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...
16. ### Need help for formula other than IF

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>...
17. ### Automatically show columns based on criteria

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...
18. ### Calculating bonus with different variable

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...
19. ### Index-match

Hello, i need help from you guys to build a form for calculating bonus. attached is an excel and the required is described below: 1- the target is to get a bonus for a person based on the activity 2- each cell under Bonus Column must equals quantity X value for the selected task 3- the value...
20. ### Need Help For Bonus Scheme

Hello, i need help from you guys to build a form for calculating bonus. attached is an excel and the required is described below: 1- the target is to get a bonus for a person based on the activity 2- each cell under Bonus Column must equals quantity X value for the selected task 3- the value...

### This Week's Hot Topics

• VBA code giving errors and stopping Excel
Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
• Disable MsgBox message
Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
• Macro Recorder into VBA, Copy Paste Data Filled Cells
Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
• Number format changes while pasting into a cell
Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
• Collating data
Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
• Sum Multiple Columns Based on Multiple Criteria
I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...