+ Reply to Thread
Results 1 to 3 of 3

Solving equation using the Solver Function of Excel

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    Baguio, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    Solving equation using the Solver Function of Excel

    hello,
    im not that well versed with excel, and im having difficulties with solving this equation using Excel 7=12x[x/(2+x)]^2/3.
    i want to find the value of x, would that be possible? thanks, appreciate any advise.
    PS. i want to use the SOLVER function of excel.

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

    Re: Solving equation using the Solver Function of Excel

    Basic procedure:

    Set up a spreadsheet to calculate f(x) at some initial guess for x. You will have one cell containing x, and one cell containing the formula for f(x).
    Then call Solver and tell it to set f(x) to a value of 7 by changing x. If you have given it a suitable starting value, it will find what value of x results in f(x)=7

    I would probably suggest you review how the newton raphson algorithm works (a quick internet search for newton's method or similar should yield several tutorials) so you will understand how the algorithm works, including important considerations for how to choose a suitable initial guess.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Solving equation using the Solver Function of Excel

    I put the Solver routine in VBA
    Press the button and the equation is solved
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ 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. Solving a multivariable equation with Excel
    By XAP in forum Excel General
    Replies: 10
    Last Post: 12-14-2009, 06:36 PM
  2. Solving an equation
    By sydmil in forum Excel General
    Replies: 6
    Last Post: 05-13-2009, 12:29 AM
  3. Replies: 6
    Last Post: 12-09-2007, 11:09 AM
  4. Excel Equation Solving...? Critical
    By eyewinkler in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2006, 09:54 AM
  5. Excel Solver is not retaining correct constraints when solving
    By GottaGetItRight in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2005, 11:30 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