colindenovo
New Member
- Joined
- May 27, 2014
- Messages
- 1
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
<tbody>
</tbody>
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>