# How to Solve Simultaneous Equations in Excel – 3 Easy Methods

You have to solve 2 linear equations for X and Y.

3X – Y = 5

4X – Y = 2

### Method-1 – Utilizing the MMULT and the MINVERSE Functions

Combine the MMULT and MINVERSE functions to solve 2 equations with 2 unknowns.

Â Steps:

• Select D13:D14Â  and enter the following formula.

`=MMULT(MINVERSE(B9:C10),D9:D10)`

Here, the B9:C10 and D9:D10Â  represent the X and Y coefficients and the constant values on the right-hand side of the equation.

Note: Press CTRL + SHIFT + ENTER since this is an array formula.

Formula Breakdown:

• MINVERSE(B9:C10) â†’ returns the inverse matrix for the matrix stored in an array. Here, the function returns the values of the inverse matrix.
• =MMULT(MINVERSE(B9:C10),D9:D10)â†’ returns the matrix product of two arrays. Here, the function multiplies the inverse matrix array with the values on the RHS and gives the output.

This is the output.

### Method-2– Solving Simultaneous Equations with an Excel Add-in

Steps:

• In C13 cell >> enter the LHS of the linear equation:

`=3*D9-D10`

Here, D9 and D10Â indicate the Initial Values of X and Y.

• Enter this formula in C14.

`=4*D9-D10`

• Click the File tab.

• Choose Options.

• Choose Solver Add-in >> click OK.

• Go to the Data tab >> click Analyze >>choose Solver.

IIn the Solver window:.

• In Set Objective, enterÂ C13.
• In To options, select Value OfÂ  and enter the value of the constant, here, 5.
• In By Changing Variable Cells, enter C8:C9.
• Click AddÂ to set the constraints.

• Enter C13 in Cell Reference.
• Choose an equal sign (=) from the dropdown list >>enter D13 in the Constraint field >> Click Add.

• Repeat the same procedure to add a second constraint and click OK.

• Choose Simplex LP in Select a Solving Method.
• Click Solve.

• Check Keep Solver Solution and click OK.

This is the output.

### Method-3: Solve Simultaneous Equations with 3 Variables Applying the Cramerâ€™s Rule

Cramerâ€™s rule is a formula in linear algebra to solve a system of equations in Excel with multiple unknowns.

Steps:

• In C11, enter the C6 cell reference.

`=C6`

C6 cell points to the coefficient of X.

• Enter all values and press CTRL + 1.

In Format Cells:

• Select Border and follow the steps shown in the image below.

• Go to C15 >> enter the values in the RHS column.
• Enter the coefficients of Y and Z in the next two columns.

• Enter the values for Dy in the second column.

• Enter the values for DzÂ in the third column.

• Go to G12Â and enter the formula below.

`=MDETERM(C11:E13)`

the MDETERM function calculates the determinant of the C11:E13 array.

• Enter the determinants of x, y, and z.

• Go to I6 cell and enter the formula below.

`=G16/G12`

G16 and G12 represent the values ofÂ  Dx and D.

This is the output.

## How to Solve Quadratic Equations in Excel

Steps:

• Go to E10 and enter the quadratic equation.

`=5*E9^2 - 4*E9 - 9`

E9 refers to the values of X.

• Go to the Data tab >> click What-If Analysis >> select Goal Seek.

In Goal Seek:

• In Set cell, enter E10 >> in To value, enter 10 >> in By changing cell >> select E9.

This is the output.

## How to Solve Linear Equations in Excel Using the Solver

Steps:

• Go to C15 and enter the linear equation.

`=3*D10-5*D11+D12`

D10, D11, and D12Â indicate the Initial Values of X, Y, and Z.

Repeat the same process for the other two equations.

• Go to the Data tab >> click Analyze >> choose Solver.

• Follow the steps described in Method 2.

This is the output.

Practice Section

Practice here.

## Related Articles

<< Go Back to Excel Solve Equation | Excel Solver ExamplesÂ |Â Solver in ExcelÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1. Hi,
I am trying to solve linear equations with multiple unknowns. Sample below. Problem is I have only one equation with multiple unknows
19.6=a+0.0124x+0.0304y+0.175z
I need a excel function to give possible values for the variables in above equation. Anyone knows how to do it?

P.S: I am not looking for solutions where we have three unknowns and hence we cant solve with less than three questions. I need to know what are the possible (not unique) values that satisfies the above equation

Thanks

2. Need more lessons on solving quadratic and linear equations.