Forum Discussion
Solved
whatif data table shows some right values and other wrong values
I'm tearing my hair out over a data table problem. I'm working out the profitability of a business proposal. In a simplified version to illustrate the problem, I have created a spreadsheet with only ...
John,
you have to swap the cell references in the data table.
Here's a link to a much simplified version of the situation, but it still shows the problem with the data table ... https://readingmencap-my.sharepoint.com/:x:/g/personal/john_readingmencap_org_uk/ERCw4olilitNmpIRlERVYeIBNtaJBOU_d54BO2GYD0Nabw?e=fxgPh6