Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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/



This was my thinking too - data tables can often do this.

The negative of data tables is that it massively slows down your spreadsheet, and cause some weird errors/glitches, but it’s essentially the same thing.


And "Solver", in case you need something really sturdy.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: