G
Guest
Hi to All
How can i use a goal Seek Function.
Where can i use this function and how?
Pls any help.
Tiya
How can i use a goal Seek Function.
Where can i use this function and how?
Pls any help.
Tiya
J
JulieD
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
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