+ Reply to Thread
Results 1 to 14 of 14

Need help to solve x

  1. #1
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Need help to solve x

    Hi guys

    I'm looking for a way to solve this formula in Excel:
    x = (12600+0.1x)*100 / 40

    (x would be 42'000).

    How can I calculate in Excel?

    Thanks!

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

    Re: Need help to solve x

    IMO, before it can be a programming problem, it needs to be an algebra problem. Dust off the algebra you learned back in early secondary school, solve the equation for x, then you will have a relatively simple formula you can program into Excel. If you need a tutorial to refresh you memory of solving these kinds of equations, I like this one: https://www.purplemath.com/modules/solvelin3.htm

    Can we assume you can solve the algebra, or do you need help with the algebra?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Re: Need help to solve x

    Hi Mr. Shorty
    Thanks for your quick response. I know how to solve the algebra by hand (stepbystep extracting the x), but I was wondering how I can calculate this with Excel?

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Need help to solve x

    you need excel solver
    Attached Files Attached Files

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

    Re: Need help to solve x

    One can use Solver for this sort of thing, especially if this is a one time task. Long term I prefer to solve the algebra expression and enter the appropriate formula.

    You indicate that you can solve the algebra for x, but are not sure how to program that expression in Excel? I would expect that x=expression consists of simple add, subtract, multiply, divide operations. What do you get for you x=expression? What questions do you have about entering that expression into Excel?

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help to solve x

    I agree that a formula would be better here.

    Walk us through the steps you would use to do this with pen and paper - we can then work a formula around that logic.
    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
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Need help to solve x

    To get a more accurate result even if 1.71931E-08 is pretty close to zero change tim's setting a bit i.e.

    Set A1 to "Min" and add the constraint
    Please Login or Register  to view this content.
    Alf

  8. #8
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Re: Need help to solve x

    I agree, I'd be very curious to solve this with a formula. Here's a step by step resolution (in German, but you get the idea)
    Attachment 646016

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Need help to solve x

    Nothing attached.
    To attach a sheet click "Go advanced" and scroll down to "Manage attachments" and follow the instructions
    And while you are at it:
    -although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile ( country will suffice, no need to be more precise).
    Thank you for helping us to help you

    - Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  10. #10
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Need help to solve x

    If formula is "x=(12600+0.1x)*100/40 that can be changed to "x=(12600+0.1x)*10/4"

    Then multiply both side of equation with 4 and multiply left side of equation with 10 changes expression to "4x=126000 +x". Then move all x'es to right side of equation and expesssion now
    becomes "4x-x= 126000"

    And "x = 126000/3" so x = 42000

    Alf

  11. #11
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Re: Need help to solve x

    Thanks Alf for solving it. Now, the 0.1x equals to 10% and should be a variable since it can change.

  12. #12
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Need help to solve x

    Here is the most general construction:

    A1: 12600
    B1: 0.1 or 10% (equivalent)
    C1: 100
    D1: 40
    X1: =A1*C1 / (D1 - B1*C1)

    Y1 (check: should return TRUE): =X1 = (A1 + B1*X1)*C1 / D1

    Derivation:
    X1 = (A1 + B1*X1)*C1 / D1
    D1*X1 = A1*C1 + B1*C1*X1
    X1*(D1 - B1*C1) = A1*C1
    X1 = A1*C1 / (D1 - B1*C1)

  13. #13
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Re: Need help to solve x

    Wow, thank you very much. It was really about solving the formula first. Grande, many thanks.

  14. #14
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Need help to solve x

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Solve add-in
    By adso in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2015, 12:01 AM
  2. Please solve this
    By loki7431 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2013, 10:58 AM
  3. ****, How to solve this?
    By mwoerd in forum Excel General
    Replies: 2
    Last Post: 04-19-2012, 04:20 AM
  4. How do I solve for n in =4^n=64
    By dpiekarz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2006, 05:39 PM
  5. need help to solve this
    By klaengur in forum Excel General
    Replies: 2
    Last Post: 05-09-2006, 04:09 AM
  6. y i cannot solve it ?
    By cjjoo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2005, 07:05 AM
  7. [SOLVED] How to solve?
    By Lee Tow in forum Excel General
    Replies: 2
    Last Post: 06-24-2005, 08: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