+ Reply to Thread
Results 1 to 4 of 4

Trying to make a solve for X formula in an old version of Excel

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    USA, Not otherwise relevant
    MS-Off Ver
    2003 SP3
    Posts
    25

    Question Trying to make a solve for X formula in an old version of Excel

    Hello all, I need to make this equation work in excel 2003, I know its old as dirt but so far it has always done everything I needed it to do so I hadnt bought a newer version.

    (X * B2)\((B3 * B9)* 336)=B15

    B15 is currently a value of 65, but that number may change, so there is a cell reference.

    Trying to solve for X.
    I did the basic equation myself, and that is easy, im just not sure how to put this in excel.
    Due to the nature of this equation, B2 and B3 may change, but that is why those are cell references rather than static numbers.

    Thanks in advance for the help.
    Last edited by BigD63; 06-11-2020 at 09:34 PM. Reason: Clarifying the fomula and request

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Trying to make a solve for X formula in an old version of Excel

    Hi,

    Just rearrange it as you would if you were trying to solve it with pen and paper, i.e.:

    =B3*B9*B15*336/B2

    will give you X.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    08-10-2017
    Location
    USA, Not otherwise relevant
    MS-Off Ver
    2003 SP3
    Posts
    25

    Re: Trying to make a solve for X formula in an old version of Excel

    Thankyou for the reply, I guess I was over simplifying it. Honestly it looked wrong at first until I worked it backwards and it is correct, thanks!

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Trying to make a solve for X formula in an old version of Excel

    You're welcome!

    Cheers

+ 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: 0
    Last Post: 01-09-2016, 02:02 PM
  2. Replies: 2
    Last Post: 04-11-2015, 12:44 AM
  3. Get code that works on excel version 2007 to work on version 2010
    By Agent1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2014, 01:23 AM
  4. trying to solve an if formula in excel
    By jamie35 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-06-2012, 05:17 PM
  5. Make 200 task: can you help me work out a formula to solve this quiz?
    By Alex Brown in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-02-2009, 08:04 AM
  6. [SOLVED] How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION?
    By HANY in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2005, 09:05 AM
  7. Replies: 3
    Last Post: 06-16-2005, 11:05 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