Using a "switch" cell to enable easy analysis on different scenarios

5.61K viewsTips and Techniques

Recently I was asked if there is a method in Quantrix to save the configuration of a set of variables, then select the configuration from a list allowing mutliple scenario analysis. I’m posting the answer here in case anyone else finds it useful.

This kind of scenario analysis can be done by using a “switch” cell in a Matrix to dictate the values passed into a model.

A “switch” can be created in a cell by using the ‘Constrain Input’ list functionality [color=”DimGray”](Right click on cell > Constrain Input > List)[/color]. The value selected from this list can then be used in an [b:ii9ud2tf]IF [/b:ii9ud2tf]statement, to dictate the values passed into the model.

I have attached an example model that shows the use of a Scenario Switch. In the example model, the Scenario Switch controls the Rate Value that is passed into the Income Growth Results table. :cool:


When I first read the subject line of this post I was expecting to see an example of using the switch function. I’ve been wondering how to use this function so it caught my eye.

After looking at the example model I realized that wasn’t the purpose.

BUT, the complex if statement gave me insight on how to use the switch function. I’ve updated the model and included it.

I think using the switch function in this situation clarifies the formula a great deal.

You are viewing 1 out of 5 answers, click here to view all answers.

Latest Questions