Hello group,
I have a large spreadsheet that I have setup as my base model. When I added a sensibility analysis ("What-if analysis") using "Data Table", I found an error I haven't been able to correct.
If I enter variable data as values, no problem, I get the expected results.
However, when I use formulas in the variables, I obtain some fake #DIV/0! errors for some of the variables. I have also found the result for some variables incorrect.
The formulas I used in my variables have nothing to do with the base model.
Have you any idea on how to solve this issue?
Do you know of the limitations of Data Tables?
My Table Data is I3:J14
Bookmarks