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

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

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

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

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

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

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