This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide.
A manual what-if analysis doesn’t require too much explanation. In fact, the example we have used in the previous article (A What-If example in Excel) demonstrates how it’s done. Manual what-if analysis is based on the idea that you have one or more input cells that affect one or more key formula cells. You change the value in the input cells and see what happens to the formula cells. You may want to print the results or save each scenario to a new workbook. The term scenario refers to a specific set of values in one or more input cells.
Manual what-if analysis is very common. People often use this technique without even realizing that they’re doing a type of what-if analysis. This method of performing what-if analysis certainly has nothing wrong with it, but you should be aware of some other techniques.
If your input cells are not located near the formula cells, you can consider using a Watch Window to monitor the formula results in a movable window.