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

1. Member
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. Member
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

#### 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,723,721,427.70852 seconds with 17 queries