DATA GOAL SEEK

Dosto aaj mein aapko data goal seek ke baarey me batane jaa raha hu, goal seek ka use hum basically total amount ko badha aur ghata kar yeh dekhne ke liye hota hai ki rate per quantity kitna hoga ya phir ussi rate par kitni quantity badhegi ya phir ghategi, iska use karne ke liye hum niche step by step dekhte hai ki goal seek ka use kaha par aur kaise kiya jaata hai.

Step 1

Quantity = 10
Rate  = 300/quantity
Total Amount = 3000

Sabse pehle worksheet me quantity, rate aur total amount ki table banaye, jaise ki niche image me diya hua hai. Dhyan rahe ki total amount ke liye aapko into (guna) ka formula lagana hai, table ke according cell C2 me lagana hai, formula hoga =A2*B2.

Step 2

Iske baad C2 me cursor rakhna hai aur Data tab me => What-If Analysis => Goal seek me click karna hai, iske baad ek box open hoga box ke 1st field [Set cell] ko kuch nahi karna hai.

2nd field [To value] me agar amount plus ya minus karni hai to vo dalna hai jaise ki table me total amount 3000 hai but [To value] field me 6000 set kiya hai.

3rd field [By changing cell] ke right me jo red color ka selection point hai uspar click karke aap select kar sakte hai ki rate ya phir quantity me se kisme change karna hai, jaise maine cell Rate changing ke liye cell B2 ko select kiya hai.

Step 3

Iske baad OK button par click karke aap dekh sakte hai ki jaise hi humne total amount badhakar 6000 kiya to selection ke according rate bhi change hoke 600 ho gaya hai, jiska matlab hai ki 6000 ki 10 cheeje me ek ka rate 600 hoga. image dekhein.

Step 4

Same process hum quantity ke saath bhi kar sakte hai. difference sirf itna hoga ki rate purana wala hi rahega aur quantity badh jayegi. image dekhein.

To dosto ummeed hai ki aapko yeh post acchi lagi hogi aur samajh me bhi aayegi gai hogi, agar kisi tarah ki baat samajh me nahi aayi ho to aap mujhe comment karke jarur batgaiye.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

Your email address will not be published. Required fields are marked *