simplified

  1. M

    Can this complex rate-of-return formula be simplified?

    =IF( ROW()-ROW(Table1[#Headers])<12, NA(), (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])))* (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])-1))* (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])-2))* (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])-3))* (1+INDEX([Monthly...
  2. L

    Relationships/Slicers help

    Hi, Fairly new to PowerPivot and I've managed to create a few working models, however I'm stuck - below is a simplified version of my data and the problem Table 1 - Is a list of All hotels, along with their country, region, etc Table 2 - is a list of all bookings made over the past 2 years...
  3. P

    Simplify If Formula

    Hi I have this formula that i have managed to get to return the results i need, but it is a it long-winded. Is there a way this could be simplified...
  4. A

    Conditional Result in Excel

    Hello guys I need your help to write the correct formula. I will explain my concern in a simplified example: CELL | Value A1 | 500 A2 | =if(A1>100, "Error: Too...
  5. Vintage79

    Using INDIRECT Across Worksheets

    Hello, I've been working through an excellent video on YouTube, but I have come across a problem that I cannot solve. Here is a simplified example from my workbook: Excel...
  6. J

    Index/Match Non-linear Logic

    I have the following table structure. I am attempting to pull in the Planning rate associated with the Part No. The structure (if you look towards the bottom of my table) is not stable - sometimes a product may have 1, 2 or 3 lines (they could, conceivably, have 10). The structure may have...
  7. R

    Can this formula be simplified?

    =IF(OR(ISNUMBER(SEARCH("*tul1*",N4)),ISNUMBER(SEARCH("*sk701*",N4)),ISNUMBER(SEARCH("*cv901*",N4)),ISNUMBER(SEARCH("*cv911*",N4)),ISNUMBER(SEARCH("*ts901*",N4)),ISNUMBER(SEARCH("*461*",N4))...

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