![]() Let’s see how we can use the goal seek function in excel. Or find the loan amount at a given interest rate which produces a monthly payment of $2000 (Example 3) How to use Goal Seek in Excel? Or you can use it to find how many units you will have to sell in a month to reach net profit of $50000 (Example 2). But it can be used for a number of different reasons as well.Įxample: You can use Goal Seek Analysis in Excel to find how much you need to score in your last exam to get an overall grade of 80 (Example 1). ![]() Use of goal seek in excel, is majorly done for financial modelling, sales forecasting etc. Goal Seek Excel is part of the What If Analysis, it helps you understand what value we should enter into an input cell to get a desired result in the formula cell. ![]() What If Analysis gives us the option to test our various scenarios and determine a range of outcomes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |