+ Reply to Thread
Results 1 to 4 of 4

Does Excel have the power to solve for x in complex quadratic equations? Please help.

Hybrid View

  1. 08-12-2016, 08:55 AM #1
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,535

    Re: Does Excel have the power to solve for x in complex quadratic equations? Please help.

    Is there a part of entering this function into Excel that you don't understand. It should be as easy as:
    1) Enter values for M, W, Icl, etc into cells in Excel.
    2) In the cell for x, enter the formula as outlined, replacing M, W, Icl, etc with references to the cells containing those values. Note that you can enter numbers in scientific notation (3.96*10^-8) as 3.96E-8.
    3) Without writing the whole thing out, it should look something like =35.7-0.028*(A1-A2)-A3*3.96E-8*A4*...

    If you are unfamiliar with creating formulas in Excel, I might suggest an introductory page like this https://support.office.com/en-us/art...e-b50a667eb491
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  2. 08-12-2016, 09:26 AM #2
    turya85
    turya85 is offline
    Registered User
    Join Date
    08-12-2016
    Location
    Galway
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Does Excel have the power to solve for x in complex quadratic equations? Please help.

    Hi Mr. Shorty,

    Thanks for your reply. Sorry maybe I wasn't clear with my question. Let's put it this way -

    Say A1, A2,A3 etc consists the value of M, W, Icl etc .... and I want the value of x to be represented in A10. Therefore, I put in cell A10 my formula as follows =35.7-0.028*(cellA1 – cellA2)-cellA3....., which is x. I do not know the value of x and need it to be computed. So you see my problem? Both the right hand side and left hand side of the equation has x. I want a solution where maybe the RHS doesn't have x.

    I hope I am clearer now.

    Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. I need to solve a complex power equation
    By mrideout in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-17-2015, 02:31 PM
  2. How can I solve for unknown variables in quadratic equation using excel?
    By erickwy in forum Excel General
    Replies: 8
    Last Post: 03-11-2015, 04:27 PM
  3. [SOLVED] Using excel to solve a value in 2 equations
    By jackleesteere in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 11:03 PM
  4. quadratic equations help needed
    By Joseph Little in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2014, 10:25 AM
  5. How do I enter a quadratic and cubit-fit equations?
    By DianeD in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-12-2006, 04:40 PM
  6. [SOLVED] solve quadratic equation system
    By Miguel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-27-2005, 10:06 AM
  7. 2 variables in 2 quadratic equations in excel
    By fsshl@centurytel.net in forum Excel General
    Replies: 5
    Last Post: 02-06-2005, 08:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1