Page 221 - TP_IT_V1.0_C10_flipbpookl
P. 221
• One-Input What-If Analysis: One-input What-If analysis allows you to examine how changes in a single input variable
impact the outcome of a formula or calculation. You typically set up a column or row of cells containing different
values for the input variable, and then observe how these changes affect the result of a formula elsewhere in the
spreadsheet. For example, if you are analysing the impact of interest rates on loan payments, you might vary the
interest rate across a range of values to see how it affects the monthly payment.
• Two-Input What-If Analysis: Two-input What-If analysis extends this concept to explore the effects of changes
in two input variables on the outcome of a formula or calculation. You set up a grid of cells containing different
combinations of values for the two input variables, and observe how changes in both variables simultaneously
affect the result of the formula. For example, if you are analysing the impact of both interest rates and loan terms
on monthly payments, you might vary both variables across a grid to see how different combinations affect the
payment amount.
What-if tool uses Data Multiple Operations and is a planning tool for what-if questions. The Multiple Operations
tool creates a formula array to display the list of results applying the formula on a list of alternative values used in the
formula. This tool uses two arrays of cells, one array contains the input values and the second array uses the formula
and display the result. This What-if analysis tool is very helpful when we want to know how much profit we earn for a
particular product for a series of selling units.
Let us take an example to conduct an analysis with one input variable. Suppose you run a café where you sell sandwiches
for `8 each. It costs you `3 to make each sandwich. On top of that, you have fixed monthly expenses of `2000. How
would your monthly profit or loss be affected by the number of sandwiches sold?
To conduct an analysis with one input variable, perform the following steps:
Step 1: Enter data in a sheet that is used to calculate the monthly profit or loss be affected by the number of
sandwiches sold.
Step 2: Click on the cell B6 and type the =B5*(B2-B3)-B4 formula to calculate the profit or loss.
Step 3: Press the Enter key. The output of the formula is displayed in cell B6.
Step 4: Enter input values on the basis of which the output is to be generated using the formula.
Step 5: Select the cell range for input values and output values.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 219

