Explanation
Before using What-If Analysis, create a proper model with input cells and calculation cells.
Example
|
Input |
Value |
|
Quantity |
100 |
|
Selling Price |
500 |
|
Cost per Unit |
300 |
Calculations
Revenue
=B2*B3
Total Cost
=B2*B4
Profit
=B6-B7
Model
|
Calculation |
Result |
|
Revenue |
₹50,000 |
|
Total Cost |
₹30,000 |
|
Profit |
₹20,000 |
Important
Keep input values in separate cells so that they can easily be changed during What-If Analysis.
Practice
Build the above Profit Model in Excel.