+ Reply to Thread
Results 1 to 2 of 2

Goal Seek and Solver may not have solution

  1. #1
    Registered User
    Join Date
    12-30-2022
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    1

    Goal Seek and Solver may not have solution

    I tried to use Goal Seek and Solver to make sure my Actual data= fitted data by changing the value of k(t), but both Goal seek and Solver cannot provide solution and gives unreasonably smaller value I expecting that the new k(t)(after using Goal Seek/ Solver) will value that not far from the original value of k(t). What kind of iteration that we can use for this kind of problem?
    Screenshot_20221230_025701.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Goal Seek and Solver may not have solution

    I don't think we can provide much guidance without knowing more about your objective function (the formula in C156) and how it behaves. The more you can tell us about your objective function (a sample file would probably be the best), the better we'll be able to help.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA required for Goal Seek solution
    By josephteh in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-31-2021, 08:39 AM
  2. Goal Seek v Solver?
    By ColW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2019, 02:50 PM
  3. Solver or Goal Seek Question
    By ljochmann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2014, 04:57 PM
  4. [SOLVED] Using Solver vs Goal Seek
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2013, 08:18 AM
  5. Goal Seek and SOLVER
    By dalebirrell in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-22-2010, 05:59 AM
  6. Excel Goal Seek vs. Solver
    By Adrian T in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2005, 10:40 AM
  7. [SOLVED] goal seek vs solver
    By neoschenker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2005, 12:06 PM

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