pay

Hello! I am having a hard time doing this in excel, and variations of it::confused: how can i calculate the monthly price i need to pay to pay down 2 accounts 2 0 where the 1st account is worth 2000 and has 0 percent interest and the 2nd account is work 10,000 and has 5 percent compounting...

Hi, I am trying to build a bonus calculator based on a tiered/stepped outcome. For example. An employee’s salary is 30,000 their max potential is 20% oftheir salary = 6000 If company profit is 3.5 million pay out 15% of a persons maxpotential At 7million pay out an additional 30% of a...

Hi, How to extract only the list of customers with balance to pay? I have attached a screenshot link and i need to get the details of customers with balance to pay in a separate table. https://ibb.co/WHZkwZF Also need to get only the total balance amount of the customer as shown in the...

Hi Hope someone can assist, looking for a calculation to give a precise value. I have this table <colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" width="76" span="2"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col...

Hi all, I have a formula that pull back the median from a list of values: =MEDIAN(IF('Median Gender Pay Gap'!N:N='Median Analysis'!G$4,'Median Gender Pay Gap'!AI:AI)) In order for to work I need to add the brackets back in: (like below) {=MEDIAN(IF('Median Gender Pay Gap'!N:N='Median...

Scenario: Looking up daily pay rates on an excel table, based on Paygrade and Years of Service. Problem: Ask Employee #1 “How many years of service do you have?” If he replies with an even number (e.g. “28 years of service”), then my Index/Match formula works as intended, therefore no issue...

Hi all! Really new to excel projects and upon doing some research on my own i find myself stuck.. I am currently working on making a time card to be submitted via excel. Currently the user will select the appropriate pay period from a drop down menu in a cell. Let’s say A1. The pay period they...

I am trying to have the number hours that employees work per pay period. Each day has a different number of hours and clients that we work with. Because each pay period ends on a different day of the week, I'm having trouble figuring out how to do this. I would also like to have the number of...

Hi, Hoping someone can help me with formula. I need to total pay components in one column be cost centre but the totals need to appear in a different worksheet I only want to pick up certain pay components though eg salary, Overtime etc Thinking I need an Index Match and Sumif or Sum product...

A kind of leave called commuted leave is credited half the half pay leave (another leave) every year. While commuted leave is credited maximum 30 in a service period, half pay leave is credited 60 in a service period (15 every year). Now if E13 = Half Pay Leave Credit, H13=Commuted Leave Credit...

I am in the middle of creating a financial worksheet for myself and my coworkers. I am having trouble figuring how much time we worked for free due to taxes. I have my tax rates calculated. I have my gross rates calculated. For example: I work 10 Hours, My pay is $50. So my gross rate is...

Hi, I require a function which looks at a ID in a certain column and only compares values across respective rows for that ID: 1) Function looks at cells containing the same ID 2) Looks at which currency is first alphabetically and then if PAY or REC to determine the Buyer Issue I am having is...

HI, So this works =IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"") If I add this +('Pay (2)'!AH2) Then in returns #Value . I just need to add that cell on another sheet =IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")+('Pay (2)'!AH2) I also tried something like...

Hi i have the table below and this vlookup formula but for the row 3 works fine but one and two doesn't pull the the data is blank. =IF(ISERROR(VLOOKUP($D$6,Vendors!$A:$J,2,FALSE)),"",VLOOKUP($D$6,Vendors!$A:$J,2,FALSE)) <tbody> Code Vendor Bill Cycle Notes Bank # Transit Acct # Contact...

Hello, I’m trying to copy cells above value 0.00 in column R and S and transpose them on to column O in the same row. Following is the snapshot of the sheet I am working with, cells in Red need to be copied and transposed on to column O. This needs to be repeated until the last populated line...

Hi Slightly weird question and I'm hoping Excel is not going to let me down. I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't - =IF(AND(R3>=T3,R3<=U3),"No","Yes") If I get back "NO" I then...

Hello. I have been going thru the payroll videos and I was trying to see if there is a video on shift premiums? Unless I missed it, maybe? I want to find a formula where a special shift premium is added to the employees pay from 7:00 pm to 1:00 am. The employee may actually start their shift...

I have this code: but when I hover over Payday it shows Payday = "="08-05 TO 08-11" and the code stops. Payday = Application.InputBox(Prompt:="What is the Pay Period?", Type:=0) ThisWorkbook.Sheets("HOURS BY ID").Range("G2:G1500").FormulaR1C1 = _ "=IFERROR(VLOOKUP(G2," & Payday & "$C:$Q,15,0)"

I have an Excel worksheet that has Overtime (OT) data for each person in the company summarized per pay period. My objectives in Excel are as follows: 1. Show a current pay period summary of OT hours by department (sorted with most hours at top); If the solution is within the PivotTable it...

I am trying to work out the interest rate of the below given cash flows. I have a principal balance of 1000 and I am paying interest quarterly, at the dates where the 1 is denoted. The interest amount is the sum of the previous quarters cash flows. So for example in the 30/09/2018 date, I will...