Forum Discussion
Excel
Jun 10, 2021Iron Contributor
Question related to Goal Seek
Hello Everyone, I have tried Goal Seek. I write this formula - Then i i have set in Term in Months in Goal Seek. like - After click in OK, it will give wrong answer in Term in...
- Jun 10, 2021
Excel I guess this is a pure mathematical issue. At 8% per year the minimum monthly payment (interest only) is 1466.67. Thus, you will never get anything lower than that. You will thus never get down to 1100, no matter how many periods.
NikolinoDE
Jun 10, 2021Platinum Contributor
Here is an example, you can expand as you like.
Can even open a bank:)))
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- ExcelJun 10, 2021Iron Contributor
- NikolinoDEJun 10, 2021Platinum ContributorUnfortunately, I can understand your project even less than Mr. Riny_van_Eekelen.
Maybe it's the translation, but what exactly do you want to achieve?
I sent you the example because it might fit into your project.
Thank you for your understanding and patience.- ExcelJun 10, 2021Iron ContributorOk sir...
Can you please explain me in details which you have given file? Please