How do you create a one variable data table in Excel?
How do you create a one variable data table in Excel?
To create a one variable data table, execute the following steps.
Select cell B12 and type =D10 (refer to the total profit cell).
Type the different percentages in column A.
Select the range A12:B17.
On the Data tab, in the Forecast group, click What-If Analysis.
Click Data Table.
To create a one variable data table, execute the following steps.
- Select cell B12 and type =D10 (refer to the total profit cell).
- Type the different percentages in column A.
- Select the range A12:B17.
- On the Data tab, in the Forecast group, click What-If Analysis.
- Click Data Table.