In school days, we used to solve mathematical equations.…where we have the result of the equation…
..but don’t have the input value.
So, if you think about to solve the same kind of problems in Excel, you have a specific tool which can help you.
Goal Seek in Excel
The basic idea is to find the exact input value and a formula can help you to to get that value.
In simple words, if you know what actual result value you want, you can use goal seek to find the best input value for getting it.
For say, you need to borrow some money from someone.
You know how much money you need, how long you want to take to pay off the loan, and how much you can pay each month.
You can use goal seek to calculate the interest rate you will need to secure with your friend.
You can solve many complex problems with the help of goal seek function.
So today, in this post, you’ll learn how to use goal seek in Excel, how it works and what are the important points you need to take care.
Let’s get started.