In addition, we can find the Goal Seek in Excel result using functions such as PMT, Future Value (FV), and Present Value (PV). The formula for calculating the actual number remains the same, and the goal seek feature will only change the dependent cell.The purpose of Goal Seek in Excel is to find the required value based on the target value.Therefore, we can easily find the values using Goal Seek in Excel. Enter the required values in the parameters.Ĭlearly, the table implies that Allen needs to sell 1000 iron rods to earn a revenue of $3,000. Step 1: Go to Data -> What If Analysis -> Goal Seek. Using Goal Seek in excel, we can find the set value with the following steps: So, if he has to increase his income to $3000, he must know how many more iron rods he needs to sell. However, the revenue he can make by selling 350 iron rods is only $1,050. So, he sells around 350 iron rods and sells each rod for $3. In simple words, the Goal Seek in Excel feature helps us find the input value to obtain the targeted output automatically.įor example, let us assume that Allen wants to make a profit of $3,000 per month by selling iron rods. Goal Seek is one of the what-if analysis tools in Excel that allow users to find the required number to achieve the targeted goal (result or value).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |