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.
I'd report it to Microsoft through File > Feedback > Send a Frown