Todays ms excel lesson 16-11-2011 (goal seek)

Excel 2453 views 15 replies
User Avatar

Govt.Job
4401 Points Joined August 2008

 

GOAL SEEK FUNCTION IN EXCEL

Purpose:

To find out the variable that derives the output that you are looking at. For e.g. you want to know how much to invest today so as to get Rs 13,000 after 3 years @ 9% interest p.a.

How to do

a)      Conventional approach

One way to fulfill your requirement is use the trial and error method to find out the results. You can input the initial investment as any value (say Rs 10,000) in cell B3 and calculate the maturity value in cell E3 as shown below

       

You can now use the trial and error method to find out the initial investment to derive the final maturity amount of Rs 13,000. By doing the same you will arrive at the following results:

 

b)      Using Goal Seek function

But there is an even easier way to find the answer. That is to use Goal Seek, an Excel function provided by Excel.

Where do I find goal seek in Excel 2007 / 2010

Go to “Data” tab to locate Goal seek

 

Where do I find goal seek in Excel 2003 or earlier

Go to “Tools” menu to locate Goal seek

Enter the following parameters and press Ok

 

The output will be displayed as follows:

 

In case excel is unable to find out the result, it will display a message as follows:               

6 Reply Share Follow
On 16 November 2011 at 13:04 Report
Replies (15)
User Avatar

Finance Manager
9232 Points Joined August 2007

Thank you Ankur ji for the important post, though i use goal seek and know about it.....but is it incomplete or the link is not seen in the post.

1 Reply
On 16 November 2011 at 13:48
User Avatar

CA
3288 Points Joined April 2010

Thank you sirjee for the important post...........

 

I haven't used Goal seek till now but i will try it today..................

 

1 Reply
On 16 November 2011 at 13:57
User Avatar

Govt.Job
4401 Points Joined August 2008
Originally posted by : Vandana Mulchandani

Thank you Ankur ji for the important post, though i use goal seek and know about it.....but is it incomplete or the link is not seen in the post.

 

This is complete post,no link this time………smiley

Reply
On 16 November 2011 at 14:06
User Avatar

B.Com. MBA & CWA
867 Points Joined March 2010

Very Nice Gi,,,,,,,

smileysmileysmileysmileysmiley

 smiley smiley smiley smiley

   smiley  smiley  smiley

      smiley   smiley

          smiley

 

1 Reply
On 16 November 2011 at 14:07
User Avatar

Company Secretary
4210 Points Joined July 2010

thanks and would definately try it...

1 Reply
On 16 November 2011 at 16:54
User Avatar

ca final
374 Points Joined November 2011

ankur sir .i try this in excel

i did not same

plz tell goal seek in detail plzz

Reply
On 16 November 2011 at 19:54
User Avatar

Govt.Job
4401 Points Joined August 2008
Originally posted by : deepali bhartiya

ankur sir .i try this in excel

i did not same

plz tell goal seek in detail plzz

 

Where you got problem?

1 Reply
On 16 November 2011 at 20:54
User Avatar

Shabda Bramha
8847 Points Joined July 2011

Highly commendable effort. Bookmarked.Looking forward to tomorrow's article.

1 Reply
On 16 November 2011 at 21:56
User Avatar

student
706 Points Joined July 2009

PLZ KEEP SHARING SUCH.......

1 Reply
On 16 November 2011 at 23:10
User Avatar

CA
210 Points Joined October 2008

Thanks Ankur for sharing this..!!

 

1 Reply
On 17 November 2011 at 08:17
User Avatar

C.A. Final Student
25 Points Joined October 2009

sir ji i tried as instructed but it says cell must contain the formula ? whr and wht formula should i put in Goal seek pls say,

and yes thnks alot for formula

Reply
On 17 November 2011 at 10:22
User Avatar

Working
59 Points Joined December 2009

thanks ankur for sharing this .looking forward for your tommorows excel tips.

1 Reply
On 17 November 2011 at 11:01
User Avatar

ca final article
76 Points Joined June 2011

Thanks ..

 

1 Reply
On 17 November 2011 at 11:08
User Avatar

Accountant
26 Points Joined December 2009

Thanq Boss

1 Reply
On 17 November 2011 at 11:38


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading