He wants to see
how the gross profit changes if the price or unit sales are different.
Create a two-variable data tableas follows to calculate gross profit as the price and unit
sales change:
a. For the range D4:K9, create a two-variable data table using the price per unit (cell
B6) as the Row input cell.
b. Use the units sold (cell B5) as the Column input cell.
Reading books is a great way to learn. Here are some of the books we recommend.
Select D4 through K9. Go to Data Tab, under forcast group there is What if analysis and then select data tables. Enter B6 as the row input cell and B5 are column input cell.