+ Reply to Thread
Results 1 to 3 of 3

Solving Simultaneous Equations with Excel

  1. #1
    Forum Contributor
    Join Date
    10-07-2015
    Location
    Tehran - Iran
    MS-Off Ver
    2013
    Posts
    111

    Solving Simultaneous Equations with Excel

    We can solve simultaneous equations with excel by using of SOLVER or MINVERSE matrix, if there is a constant value into our equations. My problem is: How we can solve simultaneous equations without the constant value such as below example?

    2x + 3y + 8z = 0
    5x – 2y + 4z = 0
    7x + 5y – 3z = 0

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Solving Simultaneous Equations with Excel

    Same way, but it's trivial: x=y=z=0
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    10-07-2015
    Location
    Tehran - Iran
    MS-Off Ver
    2013
    Posts
    111

    Re: Solving Simultaneous Equations with Excel

    What about below example:
    x – y = 0
    y – x = 0
    The answer is: x = y = c and “c” is a constant value.
    How can we get this constant value by excel? In fact, I am willing to know how we can calculate eigenvector of matrix by using excel, if we have eigenvalue of matrix?

+ 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. solving simultaneous equations.
    By yeshwant_sur in forum Excel General
    Replies: 3
    Last Post: 05-24-2012, 11:10 AM
  2. simultaneous equations/excel 2007
    By Robert2008 in forum Excel General
    Replies: 1
    Last Post: 02-20-2009, 06:05 PM
  3. simultaneous equations/matrix inversion in Excel 2007
    By Robert2008 in forum Excel General
    Replies: 1
    Last Post: 02-20-2009, 10:02 AM
  4. solving equations using Excel
    By arnold_charming in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2005, 05:25 AM
  5. solving equations using Excel
    By arnold_charming in forum Excel General
    Replies: 3
    Last Post: 12-07-2005, 02:55 PM
  6. solving equations using Excel
    By arnold_charming in forum Excel General
    Replies: 0
    Last Post: 12-07-2005, 12:30 PM
  7. [SOLVED] solving for 2 unknowns using 2 simultaneous equations
    By elaturnas in forum Excel General
    Replies: 1
    Last Post: 02-08-2005, 04:06 PM
  8. [SOLVED] solving for 3 unknowns using 3 simultaneous equations
    By elaturnas in forum Excel General
    Replies: 0
    Last Post: 02-08-2005, 02:06 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