Please see attached 'sensitivity' tab; as you can see all my inputs I'm trying to sensitize are in cells M1,M2,M3 and M4. I'm trying to see how changes to these values affect the return in cell C2.
When I manually make adjustments to the input in M3, for example, it yields a corresponding adjustment to C2. However, when I sensitize them in a data table on the right, the values are incorrect.
I suspect it has to do with a circular reference or something, but have no idea why this is going on.
please help!
Thanks
For some reason I can't attach; file is uploaded at: ufile (dot) io/uf8wa
Bookmarks