Jan 28 2021 02:25 AM
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.
Unfortunately, both approaches deliver different results.
I would be interested in where the deviations come from.
As an example, I'll attach my EXCEL file.
The sample calculation comes from a special task of gear calculation with crossed axes.
I am very grateful for any helpful answer.
R-Jensch
Jan 28 2021 02:58 AM
I'd report it to Microsoft through File > Feedback > Send a Frown
Jan 28 2021 03:04 AM
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.
Jan 28 2021 04:13 AM
SolutionAh 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.
Jan 28 2021 04:13 AM
SolutionAh 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.