I’m looking to expand a formula that can accommodate building scenarios over a span of 5 years (columns) and 10 cases (rows).

I can effectively handle the setup for one row and generate the outcomes across various years.

I can then drag the formula down to address the rest of the cases.

However, the cases might change dynamically, and I need an adaptable and general solution. Can anyone provide some guidance on this?

I’ve attached a spreadsheet where I try to explain the concept in more detail.

​  I’m looking to expand a formula that can accommodate building scenarios over a span of 5 years (columns) and 10 cases (rows).I can effectively handle the setup for one row and generate the outcomes across various years.I can then drag the formula down to address the rest of the cases. However, the cases might change dynamically, and I need an adaptable and general solution. Can anyone provide some guidance on this? I’ve attached a spreadsheet where I try to explain the concept in more detail.  Read More

​