pay

Hello, I am looking to create an Index/Match (open to other suggestions) that would based on a specific section of cells based on a conditional match. In example below, John Smith has pay/deductions designated to Department 200 and 201. If I'm looking for the Tax 2 amount for John Smith in...

Hi, I have set up a pay date sheet which shows when monthly pay is due up to 2030. I want to bring the date forward to the prior working day if the pay date falls on a weekend or bank holiday. Bank holidays have been set in a range called "Hols".. I can get it to move the pay date to the...

Hello, I am trying to figure out how to calculate based on the following. The 'closed' date will be in Cell A2. If closed transaction on 7/27, pay on Friday 8/17 If closed transactor on 7/11, then pay would be on Friday 8/3. Any transaction that closed between the 1st and the 15th of the...

My spreadsheet has 'Hours Worked' under column F and 'Pay Code' under column G. What I want to do is whenever there are '601', '603', '17' under column G 'Pay Code', I want to cut/paste values from column F 'Hours Worked' to column K. Below is my code which is partially working (it does moved...

I’m trying to put a excel sheet together for a local business We are trying to find out a method to use an excel function to calculate pay based on age using age ranges , Ie if pay age range is 18 - 21 pay would be $5.00 or if age is 21 - 24 pay would be $10. Thank you

In C1 I have the beginning date of the first pay period an employee commenced work, e.g. 18/09/2015. In C2 I have the end date of that first pay period, e.g. 01/10/2015. I thought these would be useful as formula helpers. The records begin at row 6, with the date the employee began working...

<tbody> A B C D E F G 1 JOB Operator 1 2 Current rate $10.00 3 Next Rate 4 Max Rate 1 5 Operator 1 12.00 9.00 9.75 10.50 12.00 6 Operator 2 15.00 10.00 12.00 14.00 15.00 7 Operator 3 13.00 8.50 10.25 12.00 13.00 8...

Driving Table TL_Lookup Empl # Name Trad calc Method Roth calc Method AGE Trad Amt Roth Amt Rate 004 SMITH,JOHN Gross Pay 36 22 25 076 CORTEZ,JANELLE Default 49 140 16.5 137...

Hi, I'm looking for a formula to do the following: Formula C22: Lookup Employee number VLookup - T_LOOKP,if match Lookup Age, if < 50 go to Admin and get maximium contributionamount else > 50 maximium. vlookupemployee find Traditional - calc methods and determine ifit is gross pay or...

Hello there- I am trying to do a countif function on a series of data that isn't working properly. The data is organized in three columns: $ HR $ Biz Dev $ Marketing Total Days to Pay 25 25 100 50 50 50 25 25 50 100 3 60 60 120 20 Basically I want the count if to show me how...

I am having troubles getting a payroll calculation formula set up. We have annual increases for employees (tenure) and I need to factor in different pay rates for different job types. Basic layout of Sheet 1 <tbody> A B C D E F 1 Employee Hours Tenure Type Income 2 AAA 3...

Hi I'm looking to get help creating a National Insurance Formula which is based on the factors below: you pay National Insurance contributions if you earn more than £162 a week you pay 12% of your earnings above this limit and up to £892 a week the rate drops to 2% of your earnings over £892...

Hi! I am trying to find a way to fix my issue in excel. Is there a way to make a figure populate to pay once I have changed the cell color? Multiple projects that pay out at different times according to when Invoice is paid. I already mark them green in my excel sheet when they are paid. Is...

I have a document I had the if and then statements in excel but I was messing them up yearly because it is based on years of service. I want to do it as VBA, so it will calculate automatically without having to do anything. The columns I have are YTD salary, hire date, the year (to calculate...

Needing help coming up with a formula to calculate salary expected to be used based on employee date hired, account, and pay level. See below. There are 3 tabs on my worksheet, Budget Forecaster, New Employee Tracker, and Pay Chart. Joe Smith was hired on 6/10/18 as a GS7(pay scale) which...

Need some help please; I'm working on a cost comparison and need some help with a sum that involve shift length, different rates depending on the time of day and the start time of the shift. E.g. - If an eployee starts at 04:00 set in column C, I would like the sum to pay the correct...

I am trying to figure out how to calculate the total amount of pay referencing two cells, "Total Hours Worked" and "Hourly Pay Rate". Ideally a single cell would perform all calculations. If possible I need a formula to calculate/determine: 1. Regular pay vs OT pay (OT = All hours worked...

Hi there! I was wondering if there is a formula to automatically calculate paid time off per pay period based on a starting date and amount. Each pay period (every 2 weeks on a Thursday) would be 6.1538 hours. Example: May 24 (Thurs) start with 70.1538 and every 2 weeks, June 7 (Thurs) is...

I am trying to set up an excel to show income and expenses for each period, on a two week pay schedule. I have the beginning date of the pay period in column A (starting at A8), the end of the pay period in column B (starting at B8). In column C I am trying to show what the income will be for...

Hello! I am new here, but I have a question regarding tab colors. I have a workbook that is split up into pay periods for a record of timekeeping. Each pay period is represented on an individual tab (there are several tabs in the workbook [the workbook contains pay periods for the entire...