Results 1 to 2 of 2

Thread: How to use excel solver to solve linear equation in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    64

    How to use excel solver to solve linear equation in Excel

    Hi friends, recently I was using the excel solver to solve one of the liner equation but however I was not able to solve. I just want to know How to use Excel to solve for 2 unknown in linear equation
    x + Y = 1 -----------------------------------eq1
    3x + 4Y =7 ----------------------------------eq2

    so if you have any of the information then please let me know.

  2. #2
    Join Date
    Jul 2011
    Posts
    434

    Re: How to use excel solver to solve linear equation in Excel

    According to my information there is One way to solve this liner equation:

    A1: 1
    B1: 1
    C1: =A1 + B1
    D1: =3*A1 + 4*B1


    Set Target Cell = D1
    Equal to Value of 7
    By changing cells: A1:B1
    Subject to the Constraints: $C$1 = 1

Similar Threads

  1. Excel Files - Funcres.xla and solver.xla Missing Error
    By Forrest Ranger in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 02:04 PM
  2. Replies: 8
    Last Post: 12-09-2011, 10:45 PM
  3. How to use Solver in Excel 2007
    By EricTheRed in forum Tips & Tweaks
    Replies: 1
    Last Post: 18-05-2011, 04:32 AM
  4. How to solve quadratic equation using C program?
    By KALANI84 in forum Software Development
    Replies: 5
    Last Post: 26-02-2010, 04:39 PM
  5. How To Form a linear equation in Word 2007
    By Itronix in forum Tips & Tweaks
    Replies: 1
    Last Post: 16-03-2009, 03:23 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
  •  
Page generated in 1,714,004,218.52518 seconds with 17 queries