What If - Find Any
Backsolve any output value to find the required input (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).
Learn the basics in 5 minutes with our Quick start guide. To make the most of Fontics, check out our Tips & tricks.