Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating without "goal seek" | Charts and Charting in Excel | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
goal seek vs solver | Excel Worksheet Functions | |||
Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
Goal Seek - reference a cell for "To value" field? | Excel Worksheet Functions |