Forum Discussion
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.
Hey John-
Can you supply a small portion of the workbook you're working on in order to give the forum members a better representation of the data and the formula layout? It's always nice to have a before.... i.e. what the formulas are doing now that is incorrect and an after....what they are supposed to. This will help others to test their solutions and see if they will give you the correct end result.
I know you mentioned that your model may be a little more complex then you mentioned. So maybe just a dumbed down version will suffice....
