AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Use goal seek excel3/10/2024 You could then use Goal Seek, using the product revenue target as the target value, to determine the number of sales you’d require.Įxcel will then change the value (in this instance, the sales target) to meet the target value. This kind of what-if analysis requires you to have a target value you want to reach, as well as a current value in a cell that Excel can change to try and reach your target value.įor instance, for our product revenue example, you’d need to have the number of sales in a cell. Instead, you can use the Goal Seek feature in Microsoft Excel to ponder the question and find your target answer.Īfter all, a mathematical formula is simply a question with an answer. You could work this out manually, but this could soon become complicated for more advanced queries. How many sales do you need for a product to reach a sales revenue target? This feature is available in Microsoft Excel versions from 2010 onwards, and the instructions below should remain the same across all versions. This allows you to analyze Excel data where certain variables are just unknown-until you use Goal Seek, that is. Goal Seek tries to help you by finding the correct variable you need to reach a certain goal.
0 Comments
Read More
Leave a Reply. |