Hi.... I posted this earlier before it vanished of the first page! Is it
always this busy here?? :)

Anyone mind if I re-post it
here?............................................. ...........


.............. Hi, can anyone help me with the following question- it
would be much appreciated!

Use the 'Goal seek' option on the 'Data' menu to find the value of cell
A1 in the following formula - =sum(A1+A2+A3+A4+33*(sqrt(200))) -
where A2=22, A3=3 and A4=7?


1. -23
2. -200
3. -259.69
4. -2


its either 1, 2 3, or 4! Im totally stumped! :-9


Like I said with the other question I asked- I tried doing it but I
don't know where to start! They expect me to do the questions but give
no classes in how to do them (strange way of doing things eh).


--
Deadloss
------------------------------------------------------------------------
Deadloss's Profile: http://www.excelforum.com/member.php...o&userid=29859
View this thread: http://www.excelforum.com/showthread...hreadid=495652

It would help if we knew what the formula's results was suppose to be.

JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495652

Hi

That's all that was said in the question. I've tried doing it, but I
can't! :(


--
Deadloss
------------------------------------------------------------------------
Deadloss's Profile: http://www.excelforum.com/member.php...o&userid=29859
View this thread: http://www.excelforum.com/showthread...hreadid=495652

Without knowing the formula's result it's impossible to give an answer.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495652

Hi

I've had this type of problem with the questions before - in that the
questions were vague or poorly worded and the answer didn't 'add up'.
This may be another case of this!

Many Thanks for your help anyway!

Have a good Christmas/New Year

G


--
Deadloss
------------------------------------------------------------------------
Deadloss's Profile: http://www.excelforum.com/member.php...o&userid=29859
View this thread: http://www.excelforum.com/showthread...hreadid=495652

"Deadloss" wrote:
.. Use the 'Goal seek' option on the 'Data' menu to find the value of cell
A1 in the following formula - =sum(A1+A2+A3+A4+33*(sqrt(200))) -
where A2=22, A3=3 and A4=7?

Perhaps try something along these lines
to grasp a feel on using the Goal Seek* functionality ..
*It's on the Tools menu, not Data menu

Let's say we have the formula in B1:
=sum(A1+A2+A3+A4+33*(sqrt(200)))
and we have in: A2=22, A3=3 and A4=7

Assume we want to find out what the value in A1 should be for B1 to resolve
to a target value of say, 100, given the values in the other dependent cells
A2, A3 and A4

Select B1
Click Tools Goal Seek

In the Goal Seek dialog,
ensure/make the settings as:

Set cell: B1
To value: 100 (< target value for B1)
By changing cell: A1

Click OK

The Goal Seek Status dialog will show that a solution has been found,
and we'd get the computed value in A1: -398.69
If we click OK, the dialog will dismiss and the value in A1 will be
retained.
If we click Cancel, the dialog will dismiss w/o any changes to the pre-run
state.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

"pinmaster" wrote:
Without knowing the formula's result it's impossible
to give an answer.

"Deadloss" wrote:
That's all that was said in the question. I've tried
doing it, but I can't! :(

Nor can anyone. Do you understand "pinmaster's" point?
Without knowing what SUM(A1:A4)+33*SQRT(200) should
add up to, it is impossible to determine what A1 should be,
given A2:A4.

That said, of the choices give by you, my money is on A1
being -259.69. The reason: then
SUM(A1:A4)+33*SQRT(200) is about 239 -- a round
number. Teachers usually like to use round numbers for
problems; and all the other terms are round numbers
(22, 3, 7, 33, 200). All the other choices that you
provide for A1 result in SUM(A1:A4)+33*SQRT(200)
equal to xxx.69 -- not a round number.

-259.69 would be my "guess" also but a guess is still just a guess and
not a definite answer.

JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495652