Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the meaning of goal seek in Microsoft excel?

user-image
Question added by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
Date Posted: 2015/06/04
Mohammad Basheer abu ahmad
by Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

I'm agree with all answers, Thank you Mr. Ahmed Allam for invitation

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

Goal Seek is used to get a particular result when you're not too sure of the starting value. 

 

For example, if the answer is56, and the first number is8, what is the second number? Is it8 multiplied by7, or8 multiplied by6? You can use Goal Seek to find out. 

 

Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

simply is that when one cell is a part of a formula and you want it to have a specific value. So, using goal seek to tell Excel which cell he needs to change to give you your output exactly.

I am using it most of the time it is very useful. you can find a lot of examples on YouTube.

هاشم المشارقة
by هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

It means by simple to let excel find the value of cell depending on the formula on another cell and by determining the target value and the cell which you want excel change its value.

This can be done from Data > Data Tools > What if Analysis.

Review the toturial on the link below:

http://www.homeandlearn.co.uk/excel2007/excel2007s7p4.html

More Questions Like This