Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

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.