Forum Discussion
whatif data table shows some right values and other wrong values
John,
you have to swap the cell references in the data table.
Wow! It was that simple ... thanks, Detlef, that is brilliant! All working now.
In my defence, I interpreted the prompt "Row input cell" as referring to the cell that was constant for each row of the data table and so forming a row label, and the "Column input cell" as referring to the cell that was constant for each column of the data table and so forming a column label. However, Excel wants it the other way around: the "Row input cell" refers to the cell that is varied to produce a row of column headings in the table, and "Column input cell" refers to the cell that is varied to produce a column of row labels in the data table. I reckon this is a bit ambiguous, but, hey, the problem is solved. I should have tried doing that.
Thanks again.
John
====
... What confused me was that some of the results in the table were right, and some were wrong, so I dismissed the idea that I'd just made a simple error in setting it up. I guess that must have been an artefact of my particular data.