Goal Seek
 

Hi to All
How can i use a goal Seek Function.
Where can i use this function and how?
Pls any help.

Tiya

Hi Tiya

the goal seek function allows you to change a parameter to give you the
answer that you want :)
here's a very simple example .... set up the following:

...........A...................................... .........B.
1......Departure Date..........................1/1/06
2......Current Date..............................=today()
3......Number of Weeks to departure...=ROUND((B1-B2)/7,0)
4..... Amount to save per week............100
5......Total saved..................................=B3*B4

This will give you a value of approx 3400 saved. However, you NEED to save
a total of 5000 so the question becomes how much do i have to put away each
week to get to 5000? and this is where goal seek comes in.

Click on cell B5
choose Tools / Goal Seek
fill in the following
set cell : B5
to value : 5000
by changing cell : B4
click Ok
and you will then be told how much you have to save each week to reach your
goal

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tiya" wrote in message
...
Hi to All
How can i use a goal Seek Function.
Where can i use this function and how?
Pls any help.

Tiya