m11

  1. C

    Add 2 or 3 months depending on day entered in a cell

    I have an invoice built in Excel. On that sheet I have a start date (cell M11) that is formatted as a Date in the mm/dd/yy format. I have another cell (M42) that I need to enter a formula so that if the day in M11 is before the 15th it add 2 months or if the day is equal to or later then that...
  2. D

    Match and return across two workbooks

    I'm trying to figure out if what I want to do in my head will actually work and I am coming up short with VLOOKUps, Index/Match with Indirect and I'm at a loss. I am simple trying to lookup what is in cell F1 on a sheet in one workbook across all tabs in another workbook (tab name is the same...
  3. O

    sumif? countif? i'm stuck

    hi all. is there a way to perform the following? in range sheet 2 H22:H39 look for value Sheet3 B3 and if that value is between sheet 3 L11 and M11 return 1, otherwise return 0. also, the values in these ranges are times formatted as h:mm any help would be great. thank you. EDIT..... now I...
  4. T

    Pass Up calculation from bottomline derivative

    <tbody> Im stuck trying to find simple formula to calculate derivative within a tree code. Lets say for instance: M M1 M2 M11 M12 M111 M121 M122 M1111 M11111 M11112 M11 & M12 derivative from M1 & MM121 & M122 derivative from M12 & M1 & MM11111 & M11112 derivative from M1111 ; M111 ; M11 ; M1...

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