Results 1 to 5 of 5

How to use a cell value as the "To value" value on Goal Seeking

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2013
    Location
    Brasil
    MS-Off Ver
    Excel 2013
    Posts
    8

    Lightbulb How to use a cell value as the "To value" value on Goal Seeking

    Hello,

    I have been looking for the solution for this problem for hours now, and I can't seem to find it, since the only results that show up when you include Excel goal seeking in your search are basci guides on how to use the Goal Seek feature.

    A detailed description of my problem:
    I am trying to implement a button in my worksheet, and the macro connected to it is supposed to Goal Seek with values informed by the user. I need the button implemented since most of the people who are going to use the worksheet are not much familiar with Excel.

    So, the question is, how do I use a cell value for the "To value" field of the Goal Seek feature?

    The picture below illustrates my problem - I want to reach a minimun of Y on Z by variating X.
    goal_seek.png


    Thanks in advance
    Last edited by guiismiti; 04-14-2013 at 12:31 AM. Reason: SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1