What-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 D10 calculates a total profit of 60 * $50 + 40 * $20 = $3800.
Both these excel tools can be used to help in growing the business. The planning and consolidation software can help automate and streamline your planning, budgeting, forecasting, and consolidation activities – for shorter budget cycles, a faster close, and improved regulatory compliance. They Make better decisions based on what-if analysis and scenario planning and also increase collaboration for improved accountability and planning accuracy.
Content will be erased after question is completed.