Explanation

A Two-Variable Data Table changes two inputs simultaneously.

Example

A business wants to compare:

• Quantity
• Selling Price

Quantity ↓ / Price →	₹400	₹500	₹600	₹700
50
100
150
200

Each cell represents the resulting profit for that combination.

Example

For:

Quantity = 100
Price = ₹500

Excel calculates the corresponding profit.

Steps

1. Create the original formula model.
2. Place one variable across the top row.
3. Place the second variable down the first column.
4. Put the result formula in the top-left corner.
5. Select the entire table.
6. Open Data → What-If Analysis → Data Table.
7. Select Row input cell.
8. Select Column input cell.
9. Click OK.

Practice

Create the above Quantity vs Selling Price Data Table.