+ Reply to Thread
Results 1 to 3 of 3

solve an algebraic equation on excel

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Manalapan, NJ
    MS-Off Ver
    Excel 2007
    Posts
    20

    solve an algebraic equation on excel

    Can someone help me figure out how to solve an algebraic equation on excel? The equation is X + X/(A2) = (A1 * B1). I want it to figure out "X" and show up in cell B4. Thanks.
    Attached Files Attached Files
    Last edited by vlady; 06-08-2016 at 09:21 PM.

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: solve an algebraic equation on excel

    Well,

    --- X + X/(A2) = (A1* B1)
    --> X * ( 1 + 1/(A2) ) = ( A1 * B1 )
    --> X = ( A1 * B1 ) / (1 + 1/(A2) )

    Don't you just need to apply it to B4?
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Registered User
    Join Date
    12-03-2012
    Location
    Manalapan, NJ
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: solve an algebraic equation on excel

    That worked, thanks!!!

+ 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. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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