Explanation

Goal Seek is a What-If Analysis tool used when you know the desired result, but you do not know which input value is required to achieve it.

Example

A business wants to earn ₹50,000 profit.

You know:

• Quantity = 200 units
• Cost per Unit = ₹300
• Fixed Cost = ₹10,000

But you don’t know the required Selling Price.

Goal Seek can calculate it.

Location

Data → What-If Analysis → Goal Seek

Three Important Fields

Practice

Create a simple Profit Model and identify the three Goal Seek fields.