Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Use the PMT function to calculate the Monthly Payment Now, we will use Goal Seek. On the Data tab, click the What-if Analysis button in the Forecast group and select Goal Seek from its menu.

This month’s column shows how to use Excel’s Goal Seek for data analysis.

"Chief Excel Officer" Chandoo runs down how to use Excel's Goal Seek feature to create a kind of retirement target advisor. You'll fill out a spreadsheet with the financial status you seek to ...

Goal seeking is finding the correct input when only the output is known. This is often done using the goal seek function in Microsoft Excel or what-if analysis via computer programs. Goal-seek ...

Excel Goal Seek function allows you to forecast data outcomes, especially associated with cost.