earnings

  1. C

    If person has both a Roth and 401K display earnings amount once in gross earnings row.

    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...
  2. C

    If person has both a Roth and 401K display earnings amount once in gross earnings row.

    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...
  3. P

    Enter department next to earnings, deductions etc.

    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...
  4. C

    averageif

    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...
  5. C

    Cannot pass a variable between subs

    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...
  6. C

    Using Sumifs in VBA where range changes

    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...
  7. J

    Pull rows from 1 file to another based on 2 criteria

    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...
  8. N

    Help with nested IF function

    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...
  9. sk1mcguire

    Finding a title in a range of multiple dates

    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...
  10. C

    Excel Conditional Formating: Earnings above and over

    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...
  11. N

    amount divided by years and get per month valve.

    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...
  12. M

    SUMIF Function Various Conditions

    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...
  13. A

    VBA code that can get required data from excel sheet

    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...
  14. M

    Very simple - but i need help

    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...
  15. B

    sumif with a range of cells as criteria

    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...
  16. A

    Point at which a range of cells equals specified value

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top