Best formula to use for creating scenarios?

[kcin]

Hello,

I'm looking for some advice as to what the best and easiest formula is for adding in several different scenarios into my model. I would like to create several different scenarios with different assumptions that I can have my model run through by having the user or myself toggle a cell to pick the scenario of their choice.

I have seen other people use the choose function with a data validation list while others have used offset and match with a list.

Any suggestions or help would be appreciated, thanks in advance.

 

[SteveO59L]

It is almost entirely dependant upon what you are trying to achieve

 

[kcin]

Basically I want a separate sheet with all of my different pricing and assumption scenarios on it. Then based on the scenario I want to flow through my financial model I would like to just select the pricing and assumptions (Bull, Base, Bear, Custom for example) and have it flow through and spit out the results.