You can use Scenarios to see what would happen to your bottom line figure if you change certain values.
For example, you may want to know what would happen if you change per unit price of your product. How would it impact revenue and profit?
You can enter a cell that you would be changing (example, unit price) or range of cell (example C4:C7) to create different scenario. Go to What If Analysis in Data tab and select Scenario to perform the function.
