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

Copper Contributor

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.

1 Reply

@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

 

S0041.png