What If - Find Any (Dynamic Goal Seek)
Run goal seek on any cell (including formula cells).
Input Parameters/Data
Input Variable(s): Input driver(s) of the model. For each item, add Name and Reference (cell reference of its value).
Output Variable: Output of interest (e.g. Valuation, Profit, NPV, IRR etc.). Add Name and Reference.
Notes
Input Cell references can be any cell in Excel (i.e. including cells with formulas).
Output
Excel Chart: Output chart of the "Any" analysis.
Data: Output data used for the chart(s).
View demo here
Learn the basics in 5 minutes with our Quick Start Guide. To make the most of Fontics, check out our Tips & Tricks.