Forum Discussion
Solved
What-if/Data table Problem
I tried to use the What if data table functionality contained in Excel. Due to my skepticism about the functionality, I also calculated the results delivered in the traditional manner with equations...
Ah yes. The input cells should not refer to the arguments of the original formula. If you replace the formula in G3 with its value, while keeping the formulas in H3:L3, the data table will return the correct values.
In the meantime I have found out that for the calculation of the values in the data table it is crucial whether the values of the row input cells are calculated or not.
Please look in my extended example in the Excel file.
Ah yes. The input cells should not refer to the arguments of the original formula. If you replace the formula in G3 with its value, while keeping the formulas in H3:L3, the data table will return the correct values.