Create Different Scenarios $|$ Scenario Summary $|$ Goal SeekWhat$-$If Analysis in Excel allows you to try out different values $($scenarios$)$ for formulas. The following example helps you master what$-$if analysis quickly and easily.Assume you own a book store and have $100$ books in storage. You sell a certain $\%$ for the highest price of $$50$ and a certain $\%$ for the lower price of $$20.$If you sell $60\%$ for the highest price, cell D$10$ calculates a total profit of $60*$ $$50+40*$ $$20=$ $$3800.$Create Different ScenariosBut what if you sell $70\%$ for the highest price? And what if you sell $80\%$ for the highest price? Or $90\%,$ or even $100\%?$ Each different percentage is a different scenario. You can use the Scenario Manager to create these scenarios.Note: You can simply type in a different percentage into cell C$4$ to see the corresponding result of a scenario in cell D$10.$ However, what$-$if analysis enables you to easily compare the results of different scenarios. Read on$\mathrm{.}1.$ On the Data tab, in the Forecast group, click What$-$If Analysis$\mathrm{.}2.$ Click Scenario Manager.The Scenario Manager dialog box appears$\mathrm{.}3.$ Add a scenario by clicking on Add$\mathrm{.}4.$ Type a name $(60\%$ highest$),$ select cell C$4(\%$ sold for the highest price$)$ for the Changing cells and click on OK$\mathrm{.}5.$ Enter the corresponding value $0\mathrm{.}6$ and click on OK again$\mathrm{.}6.$ Next, add $4$ other scenarios $(70\%,80\%,90\%$ and $100\%).$Finally, your Scenario Manager should be consistent with the picture below:Note: to see the result of a scenario, select the scenario and click on the Show button. Excel will change the value of cell C$4$ accordingly for you to see the corresponding result on the sheet.Scenario SummaryTo easily compare the results of these scenarios, execute the following steps$\mathrm{.}1.$ Click the Summary button in the Scenario Manager$\mathrm{.}2.$ Next, select cell D$10($total profit$)$ for the result cell and click on OK$.$Result:Conclusion: if you sell $70\%$ for the highest price, you obtain a total profit of $$4100,$ if you sell $80\%$ for the highest price, you obtain a total profit of $$4400,$ etc. That's how easy what$-$if analysis in Excel can be$.$Goal SeekWhat if you want to know how many books you need to sell for the highest price, to obtain a total profit of exactly $$4700?$ You can use Excel's Goal Seek feature to find the answer$\mathrm{.}1.$ On the Data tab, in the Forecast group, click What$-$If Analysis$\mathrm{.}2.$ Click Goal Seek.The Goal Seek dialog box appears$\mathrm{.}3.$ Select cell D$10\mathrm{.}4.$ Click in the $\text{'}$To value' box and type $4700\mathrm{.}5.$ Click in the $\text{'}$By changing cell' box and select cell C$4\mathrm{.}6.$ Click OK$.$Result. You need to sell $90\%$ of the books for the highest price to obtain a total profit of exactly $$4700.$Note: visit our page about Goal Seek for more examples and tips. Send excel link please