ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the meaning of goal seek in Microsoft excel?

user-image
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
تاريخ النشر: 2015/06/04
Mohammad Basheer abu ahmad
من قبل Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

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

FITAH MOHAMED
من قبل 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
من قبل 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.

هاشم المشارقة
من قبل هاشم المشارقة , 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

المزيد من الأسئلة المماثلة