Excel What If Tutorial

If you have more than two variables in your analysis problem you need to use scenario manager tool of excel.

Excel what if tutorial. The if function is a built in excel function that checks for a condition. What if analysis in excel is a tool in excel that helps you run reverse calculations sensitivity analysis and scenarios comparison. However excels what if analysis function was designed for just such an occasion. Otherwise the false value is returned.

Decision making is a crucial part of any business or job role. For details refer to the chapter what if analysis with scenario manager in this tutorial. To use excels what if analysis tool begin by clicking on the data tab on the ribbon and locating the what if analysis tool button under the data tools section. Now well dig into what if analysis in excel.

You can use several different sets of values in one or more formulas to explore all the various results. For example you can do what if analysis to build two budgets that each assumes a certain level of revenue. By using what if analysis tools in excel you can use several different sets of values in one or more formulas to explore all the various results. In such a case any non zero value is treated as true and zero is treated as false.

Assume you own a book store and have 100 books in storage. If function is one which are used the most often in excel. Click on the what if analysis button and choose scenario manager from the list of options. If the condition is met the true value is returned.

First select all the cells that will change. Error occurs when the given logicaltest argument cannot be evaluated as true or false. You sell a certain for the highest price of 50 and a certain for the lower price of 20. What if analysis in excel allows you to try out different values scenarios for formulas.

What if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. If is a logical function. When you can take decisions which are informed based on data the outcome of the business or project or task is always more in control. If function you can learn here what if function is and how to use it.

The excel if function will work if the logicaltest returns a numeric value. The syntax is as follows. The following example helps you master what if analysis quickly and easily.