+ Reply to Thread
Results 1 to 4 of 4

Single variable algebra formula - use Solver function?

Hybrid View

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    Shanghai
    MS-Off Ver
    Excel 2010
    Posts
    23

    Single variable algebra formula - use Solver function?

    I have a simple single variable algebra formula that I can't seem to solve using the Solver function. It's not a homework problem, but a formula that I'd like to be able to solve repeatedly and quickly using different inputs.

    The formula is: A1 = (1/A2)*A3+(A4/((1+A2)-g))

    A1 through A4 all have values in the cells, e.g.:
    A1=15
    A2=0.10
    A3=0.48
    A4=0.12

    solving for g

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,415

    Re: Single variable algebra formula - use Solver function?

    Is there a reason to use Solver (other than you don't want to do the algebra)? Solver should solve this fairly readily, though, if you want to solve it quickly and repeatedly, I would do the algebra. If I did it right:
    A1=A3/A2+A4/(1+A2-g)
    A1*(1+A2-g)=A3/A2*(1+A2-g)+A4
    A1+A1*A2-A1*g=A3/A2+A3-A3*g/A2+A4
    A1+A1*A2-A3/A2-A3-A4=A1*g-A3*g/A2=g*(A1-A3/A2)
    (A1+A1*A2-A3/A2-A3-A4)/(A1-A3/A2)=g

    Did I do that right?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    12-19-2012
    Location
    Shanghai
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Single variable algebra formula - use Solver function?

    Thanks MrShorty - I think the algebra looks sound. The reason why I wanted to use solver is because I'll be applying this formula into different workbooks which may have my inputs in different cells other than A1-A4 and having to rewrite this equation each time seems like a headache. Also, I wanted the flexibility of adding or removing from the equation.

    I guess what I'm really asking is how to use the Solver function properly. I tried following a few different tutorials on the web (each with a diff method), and each time the solver function could not find a solution.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,415

    Re: Single variable algebra formula - use Solver function?

    We would probably need to see your Solver model, but I see no reason why Solver should have any trouble finding any of the variables. You haven't specified where you will put g. If I were setting this up, it would probably look something like:

    1) A1=formula as given, using some initial guess for g (you haven't yet specified where you will put g.
    2) B1 would probably hold the desired 15 (or whatever your desire input for A1)
    3) C1 would be =A1-B1.
    4) Solver model would be
    a) Set Target Cell: C1
    b) to a value of 0
    c) by changing: g (whatever cell you choose to put g in)

    Does that sound like what your other Solver tutorials have been suggesting?

+ 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. Excel algebra function
    By Lofteren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2014, 06:17 PM
  2. [SOLVED] Solver - SolverAdd using variable in variable constrains doesn't work
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2014, 03:19 PM
  3. [SOLVED] Algebra formula
    By Aland2929 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2013, 08:22 AM
  4. [SOLVED] Function to check to see if variable is an array or only a single value?
    By SndGenRX7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 11:03 AM
  5. Algebra function graphs with Excel?
    By Ed in forum Excel General
    Replies: 3
    Last Post: 02-07-2006, 01:25 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