broke

  1. T

    Multiple criteria formula

    I need to write a formula that will look at someone's hire date (C3) and if that is before 09/01/07 then it will calculate number of years they will have been here I have the year end date in C1. Based on number of years it takes salary (J3) and multiplies by % the years are broke down with the...
  2. J

    Getting #N/A on a sumif formula!

    I do sumifs ALL the time. I used NAMED RANGES, all the time. Today, when i enter <tbody> =SUMIF(OnZats,"Y",DutyifPaid) </tbody> and <tbody> =SUMIF(OnZats,"N",DutyifPaid) </tbody> i get $0 for the first one and i get #N/A for the second! I copied all the data to a new sheet and is...
  3. J

    Cutting data form one sheet and pasting into last row on another sheet

    Hi, i am looking to use VBA to cut data from one sheet (A1 for example) then paste into another sheet but within the second sheet there is a list of data, i need the formula to find the last entry then paste below it. (obviously assigning this to a button) i have managed to create something...

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