3 ms·
Excel has "Scenario Manager", "Goal Seek", and "Data Table" for What If Analysis. In particular, "Data Table with Multiple Arguments" seems like a similar/more
by phonon 2y ago
Excel has "Scenario Manager", "Goal Seek", and "Data Table" for What If Analysis. In particular, "Data Table with Multiple Arguments" seems like a similar/more powerful version of what you are doing, which you don't address.[0]
[0] https://www.xelplus.com/excel-what-if-analysis-data-table/ https://www.xelplus.com/excel-what-if-analysis-data-table/