Scenario Analysis - can excel help?

[colindenovo]

Hi Guys,

I'm trying to do some scenario analysis in Excel and am currently populating the table manually.

Just wondering, is there a way to generate all possible scenarios within excel using a formula?

The first few rows of the table look like below, and as its going to take me until 2018 to finish it I thought I'd ask for help

Thanks,

Colin

N	N	N	N	N	N	N	N
Y	N	N	N	N	N	N	N
Y	Y	N	N	N	N	N	N

<tbody>
</tbody>