answersLogoWhite

0

Goal Seek is used to obtain a value as part of a calculation that will result in your formula a particular result. As a simple example do the following:

In cell A1 type 10. In cell A2 type:

=A1+B1

You will initially get 10 in A2. Say you now wanted to find out what value you would put in B1 so that the formula in A2 gives a total of 16. Obviously you know that it would be 6. What you can do is go to the Tools menu and select Goal Seek. In the dialog box that comes up you will get 3 things to fill in.

In the Set Cell box, type A2

In the To Value box, type 16

In the By Changing Cell box type B1.

The result will be the appearance of 6 in cell B1. Obviously that is a simple example that you could work out in your head, but occasionally there will be cases where you want to find a value that is not so easy to work out. That is when you use Goal Seek.

User Avatar

Cleve Schultz

Lvl 10
3y ago

Still curious? Ask our experts.

Chat with our AI personalities

ReneRene
Change my mind. I dare you.
Chat with Rene
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao

Add your answer:

Earn +20 pts
Q: What is goal seek in excell?
Write your answer...
Submit
Still have questions?
magnify glass
imp