earnings

If the person has a Roth and 401K contribution I need earnings to display in only one of the rows, not both. <colgroup><col><col><col span="2"><col span="5"></colgroup><tbody> Name Earnings Gross Earnings Type 401K 401L Roth Total Name 1 6/18/2012 574.75 401 28.74 28.74 Name 1...

If the person has a 401K & Roth, we only need to report the Gross Earnings once. I can't get the formula right. <colgroup><col><col><col span="2"><col span="5"></colgroup><tbody> Name Date Earnings Gross Earnings Type 401K 401L Roth Total Name 1 6/18/2012 574.75 401 28.74 28.74...

Hi all, I would like to use a VBA code so that to copy next to each earnings or deductions or contributions, the department which is in col. “C”. Therefore, that the rows are not stably and I present just an extract of data. There are also deductions & contributions. Below the original data and...

I have a companies earnings that if there are no earnings in that year i need to take the average of last three months. SO if my column AO (TOTAL "Months average earnings") is 0 i want the column AQ to show me the average of the last three months so what formula will i use i have this so...

Hi Can anyone please help? Really struggling as a novice on VBA to pass a variable between 2 subs... The first sub works fine and counts the number of rows in the data and stores in variable i, which is then used in that sub routine. The second sub that runs from a button click, I need it to...

Hi I am using a simply Sumifs formula, however this is across a data range that will change This is the formula and works as is Range("L6").Select ActiveCell.Formula = "=SUMIFS('Apps Indicative Earnings Report'!$K$11:$K$73,'Apps Indicative Earnings Report'!$G$11:$G$73,'INVOICE CALC'!H6,'Apps...

Every quarter, I have to do bonus statements for our sales rep. Part of that includes giving them the detail that make up their sales for the quarter. I have a master spreadsheet that contains all of the information for all of the reps. Normally I filter that for each rep, copy and paste their...

Hi everyone I'm trying to complete a spreadsheet for our group benefits. Our one benefit is based on a graded schedule(66.67% of the first 6000 monthly earnings, 55% of the next 3000 monthlyearnings, then 40% of the remaining earnings up to a maximum benefit of 8000per month. I have a...

Hello Sirs! I have a file that lists a title as of a certain date. In the columns I have Employee Number, Title, effective date of title. Take one for example: Emp No Title Date 5298 Staff Acct 7FEB2007 5298 Staff Acct1 8MAR2009...

Hi can some one help be with a formula for conditional formating. I have a database of 12 months earnings (A - L Coloumn) i want a formula for if it is above the average and another when it is below. I have used the conditional above formula but it tends to hightlight all even if they are...

I am looking for a excel formula: Lets suppose I have some earnings (amount) in one cell and 1 year, 8month and 10 days is mentioned in other cell. I want to divide available earnings (amount) by 1 year, 8month and 10 days and want to get earnings per month, please help me to fabricate excel...

I have an exported excel spreadsheet listing ledger numbers mixed in with text. Under the ledger numbers there are earnings and deduction codes with amounts. On a separate excel tab I have ledger codes that I want to look up on the first sheet and sum the amounts of only the earnings codes. I...

Need web data in excel sheet automatically https://www.zacks.com/stock/quote/AA?q=aa?q=AA https://www.zacks.com/stock/quote/AA/detailed-estimates Dear Members I need to zacks data in excel sheets automatically Then I need this table data in readable Form Like from this table <tbody> Next Report...

I am trying to get an IF OR function to work. Can I please get the formula from someone ? My head hurts.... I have a spreadsheet - Column B has names in it - Fred, Barney, Wilma, Betty and many others, these names appear in random order down the column. In Column E I need to calculate the...

Hi, What formula should I use to sum up the amount in a trial balance that relate to a range of cells. In this case i want to sum up the amounts in multiple accounts. I know i cant do a vlookup since i can only do 1 value and a sumif would work but then i'd rather not have to type each account...

I have data that shows the amount of earnings earned each quarter by customer on sheet 1 <tbody> Customer Quarter Quarterly Earnings 1234 1Q16 $5.00 1234 2Q16 $10.00 1234 3Q16 $15.00 5678 1Q16 $5.00 </tbody> On sheet 2, data shows <tbody> Customer Earnings Due Quarters To Be...