In Excel, three primary tools are available for performing What-If Analysis: Scenarios, Goal Seek, and Data Table. To recap the last couple of months, here are brief definitions of Scenarios and Goal ...

Two-Variable Data Table Setting Up a Two-Variable Data Table: List one set of values horizontally and the other set vertically. Enter the formula above the vertical list of values.