Excel has a help function. I would heartily recommend it.
--
David Biddulph

"lawson" wrote in message
...
How is this function used?

if i have a formula in c5, that reads '=b9^1.7', and i want to set that
cell
equal to 44 by changing cell b9, how do i use thie 'backward' function to
do
that?

"Gary''s Student" wrote:

Goto Google Groups:

http://groups.google.com/grphp?hl=en&tab=wg

and enter the following in the Search Groups Box:

"goal seek function" group:*Excel

"lawson" wrote:

Hello,

i wish to create a function that runs GoalSeek.

if, for example, A1 is where i sould type the function, then B1 would
be the
value to be set, and C1 would be the cell to change till it equals B1,
by
changing the value in A1.

A1 = GS(Target Value, Cell to be set to Value)
= GS('B1','C1') '(ie, can be typed in any cell, referencing any
cells)

which would produce a value that looks like a typical Goalseek value,
2.639568392784

any help would be greatly appreciated

G