🔹 Target Value Find Karna kya hai?

Excel mein Target Value Find Karna ka matlab hai kisi desired/final result ko achieve karne ke liye required input value ko calculate karna.

Iske liye Excel mein Goal Seek ka use kiya jata hai.

Simple words mein: Result pata hai, lekin us result tak pahunchne ke liye input kitna hona chahiye — ye find karna Target Value Finding hai.

1. Simple Example

Maan lijiye:

• Sales = ₹1,00,000
• Expenses = ₹70,000
• Profit = ₹30,000

Formula:

=Sales-Expenses

Ab business ka target hai:

Profit = ₹50,000

Question:

₹50,000 profit ke liye Sales kitni honi chahiye?

Goal Seek target value ko achieve karne ke liye required Sales find karega.

Result:

Sales = ₹1,20,000

2. Goal Seek mein Target Value

Goal Seek mein To Value field mein target value enter ki jati hai.

Example:

Yahan ₹50,000 Target Value hai.

3. Target Value Find Karne ke Steps

Step 1

Excel worksheet mein formula aur data prepare karein.

Step 2

Go to:

Data → What-If Analysis → Goal Seek

Step 3

Set Cell mein result/formula wala cell select karein.

Step 4

To Value mein desired target enter karein.

Example:

50000

Step 5

By Changing Cell mein wo input cell select karein jise Excel change karega.

Step 6

OK par click karein.

Excel required input value calculate karega.

4. Student Marks Example

Suppose student ke marks:

Student ka target hai:

Percentage = 75%

Agar Maths marks ko changing cell banaya jaye, Goal Seek calculate kar sakta hai ki 75% target achieve karne ke liye Maths mein kitne marks required hain.

5. Sales Target Example

Suppose:

Product Price = ₹500

Formula:

=Price*Quantity

Target Revenue:

₹1,00,000

Goal Seek:

Set Cell → Revenue
To Value → 100000
By Changing Cell → Quantity

Result:

Required Quantity = 200 units

6. Savings Target Example

Suppose:

Monthly Saving = ₹8,000
Months = 12
Total Saving = ₹96,000

Target:

₹1,20,000

Goal Seek se required monthly saving find kar sakte hain.

Set Cell → Total Saving
To Value → 120000
By Changing Cell → Monthly Saving

Result:

₹10,000 per month

📊 Target Value ke Common Examples

⭐ Important Difference

Target Value ≠ Changing Value

Target Value:
Jo final result humein chahiye.

Changing Value:
Wo input jise Excel change karke target achieve karta hai.

Example:

Target Profit = ₹50,000
Changing Value = Sales

⭐ Exam Points

• Target Value ka matlab desired/final result hai.
• Excel mein target value find karne ke liye Goal Seek ka use hota hai.
• Goal Seek mein target To Value field mein enter kiya jata hai.
• Set Cell mein formula/result cell hota hai.
• By Changing Cell mein input cell hota hai.
• Target value finding का use financial, sales, education aur business calculations mein hota hai.