What if excel

Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information.

Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! For more information on data tables, check out this article from Microsoft. Function calculating the monthly payment. Selecting cell B7. Selecting Goal Seek from the drop-down menu. Entering the desired values into the dialog box and clicking OK. Clicking OK. The completed Goal Seek and calculated value.

The Financial command. Selecting the PMT function. Entering values into the necessary fields. The monthly payment, not including interest. Excel includes many powerful tools to perform complex mathematical calculations, including what-if analysis. This feature can help you experiment and answer questions with your data, even when the data is incomplete. In this lesson, you will learn how to use a what-if analysis tool called Goal Seek. Optional: Download our practice workbook.

Whenever you create a formula or function in Excel, you put various parts together to calculate a result. You can use the Scenario Manager to create these scenarios. Note: You can simply type in a different percentage into cell C4 to see the corresponding result of a scenario in cell D However, what-if analysis enables you to easily compare the results of different scenarios. Read on.