When you know the result but are not sure of the input that would bring the desired result, Goal Seek function can help. Goal Seek is one of the” What If” analysis functions in Excel.
For example, if you know that you want to have revenue of 120,000 USD and you are selling 1000 products. You can use Goal seek function to find what should be the price of the product. The cell that contains result (120000 in our example) must contain a formula.
