Forum Discussion
Alexs465
Apr 19, 2024Copper Contributor
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
6 Replies
Sort By
- dickyprasetyaCopper Contributor
HiAlexs465 .. 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?
- Riny_van_EekelenPlatinum Contributor
dickyprasetya Better to start a new thread for unrelated questions. But now that you are here alreade, the answer is no.
- dickyprasetyaCopper Contributor
Riny_van_Eekelenthanks for the answer
- Riny_van_EekelenPlatinum Contributor
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:
- Alexs465Copper Contributor@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.- Riny_van_EekelenPlatinum Contributor
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.