Explanation

Goal Seek works backward.

Instead of asking:

What profit will I get from a given price?

you can ask:

What selling price do I need to achieve ₹30,000 profit?

Go to:

Data → What-If Analysis → Goal Seek

Example

Current model:

Input

Value

Quantity

100

Selling Price

500

Cost per Unit

300

Desired Profit

₹30,000

Goal Seek settings:

Set Cell: Profit cell
To Value: 30000
By Changing Cell: Selling Price

Excel calculates the required selling price.

Practice

Find the selling price required to achieve:

₹40,000 profit

while keeping Quantity and Cost unchanged.

PreviousNext