• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to use Goal Seek in Excel

October 12, 2014 by Admin Leave a Comment

Microsoft Excel has a Goal Seek feature which can be used to derive value of a cell based on the result set for the cell containing a formula. Let us see this with an example that does a simple addition. In the below screenshot, you should notice that the sum of A3 to E3 is calculated in F3.

Simple Addition Formula in Excel

Now let us say that you want the final result in F3 as “350000” and this should be achieved by changing the value of C3. For this scenario we can use Goal Seek feature to find out the value to be entered in C3.

In Excel 2011 for Mac, Goal Seek can be accessed from Tools menu.

Goal Seek in Excel 2011 for Mac

Enter the Set cell to the cell containing formula i.e F3

Goal Seek Screen in Excel

Then enter the final result that you need to arrive in “To value” field i.e 350000

Goal Seek To Value

Click Ok button after entering the cell that needs to be changed to get final result. The following Goal Seek Status screen will be displayed with “found a solution” message.

Goal Seek Status screen in Excel

Though we have taken a simple problem do explain Goal Seek feature. This feature will be quite handy when you are working with complex formulas and want to try out different values.

Filed Under: Excel, MS Office Tagged With: excel 2011, Goal Seek

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023