Forum Discussion

Harjeetsaini10's avatar
Harjeetsaini10
Copper Contributor
Dec 30, 2020

What-If Analysis ->Data Table - Formula/Mathematical formula used?

HI,

I am working on one of the projects where I need to match the data manually genearted by Excel ->What If Analysis - Data Table.

I need the reference to how excel works in the back-end for the Data table function.

excel
Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 30, 2020

    Harjeetsaini10 

     

    Excel simply substitutes the values in the row above the data table and/or the values in the column to the left of the data table into the formula in the upper left corner.

    In the screenshot below, the formula is =A1+A2.

    A1 is replaced with the values of B4, C4, ...

    A2 is replaced with the values of A5, A6, ...

     

    So for example B5 is calculated as =B4+A5, and H10 is calculated as =H4+A10

     

     

Resources