Forum Discussion
Excel what if analysis issues etc
Hi I have an issue on what if analysis, i tries to insert the numbers however the table outcome answers are the same ... is there any issues with the setting . Thanks in advance kind regards Alex ...
Alexs465 Well you don't say anything about the underlying calculation but it seems you have incorrectly set-up the row and column references for the data table.
Set-up the data table like this:
Press OK (and do some number formatting) to achieve this:
- @Riny hi still not working
even all numbers are the same -> still not taking it for unknown reason ? I press even f9, I had the Microsoft team online couldn't resolve it, about 2 hours with him ,thank you for your response and help.Alexs465 Save your file to OneDrive or similar and share a link that gives full access to it her. This isn't rocket science and should be easy to resolve.
