Forum Discussion
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 D...
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