advanced excel formulas

  1. H

    Automatically add new Month and pick values automatically based on Month no and subtract from previous month

    Hi All, I am struggling to write a formula which will check the current month and then subtract from the current month the previous month. Your help would be appreciated. DEFGHIJKLMNOPQRST12M534ExpenditureM1M2M3M4M5M6M7M8M9M10M11M12Current MonthMoM MovementMovement %5Expense...
  2. O

    IF statement needs TEXT "NULL" on "column B2" when "Column A2" reads NULL.

    Hi, I am tracking 'aging overdue invoices', and I am creating an IF statement formula where it finds the total per days outstanding. Due to the reason that My database have the correct updated syntax script my output provides the correct "days outstanding" and many ROWS I get the text "NULL"...
    • O_ch
    • Thread
    • advanced excel formulas excel & countifs excel advance
    • Replies: 19
    • Forum: Excel Questions
  3. K

    Reversed Gantt Chart Formulas

    Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...

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