Excel what if analysis issues etc

[Alexs465]

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 

[#2]

@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:

[#3]

@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.

[#4]

@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.

[#5]

Hi@Alexs465 .. sorry for OOT. Actually i'm user simple goal seek analysis for daily working. and now i want to buy tablet (xiaomi tab) it means that excel is not full version like on notebook. on tablet, excel is mobile version. i curious, is it possible using goal seek analysis on excel mobile version?

[#6]

@dickyprasetya Better to start a new thread for unrelated questions. But now that you are here alreade, the answer is no. 

[#7]

@Riny_van_Eekelenthanks for the answer