Are you finding ways to solve the system of linear equations in Excel and searching for the easiest guide? Then I think you have come to the right place. In this article, I’ll show 2 easy and useful methods to solve the system of equations in Excel with sharp steps.

**Download Practice Workbook**

You can download the free Excel workbook from here and practice independently.

**2 Ways to Solve System of Equations in Excel**

Here’s the dataset that we’ll use to explore the methods, it has three equations of three variables.

**1. Using MINVERSE and MMULT Functions to Solve System of Equations**

First, we’ll apply the **MINVERSE **and **MMULT **functions to solve the equations. For that, I have placed the variables of x, y, and z in a matrix- A and the constraints in the matrix- B.

According to matrix notation, we know that we can write: **AX = B**. here, X is the matrix of the unknown variables.

So to find X, we can write **X = A‾ ¹B**. Now let’s find **A‾ ¹** first.

**Steps:**

- First, select the empty cells of the
**A‾ ¹** - Then write the following formula in the formula bar-

`=MINVERSE(C9:E11)`

- Next, hit the
**ENTER**button just. You may have to press**CTRL + SHIFT + ENTER**in the earlier versions of excel as it is an array formula.

Then soon after you will get the inverse matrix like the image below.

Now it’s time for the final operation to find the variables.

- Select the cells of the X matrix.
- After that type the following formula in the formula bar-

`=MMULT(C13:E15,H9:H11)`

- Finally, just press the
**ENTER**button to finish. Here also, you may have to press**CTRL + SHIFT + ENTER**in the earlier versions of excel as it is an array formula.

**Read More:** **How to Solve for x in Excel (2 Simple Ways)**

**Similar Readings**

**How to Solve Nonlinear Equations in Excel (with Easy Steps)****Solve Polynomial Equation in Excel (5 Simple Methods)****How to Solve Cubic Equation in Excel (2 Ways)****Solve Algebraic Equations with Multiple Variables (3 Ways)****How to Solve Colebrook Equation in Excel (3 Simple Ways)**

**2. Applying Excel Solver Add-in to Solve System of Equations**

There’s another smart way to solve the system of equations in excel, which is using an **Add-in** of Excel. Excel has an **Add-in **named **Solver **which can easily solve the system of equations. And it’s quite helpful for a large number of equations. First, we’ll activate the **Solver Add-in.** If you know how to activate then skip these steps.

**Steps:**

- Click on the
**File**tab beside the**Home tab**.

- Next from the appeared menu, select
**Options**.

- Click on
**Add-ins**. - Later, select
**Excel Add-ins**from the**Manage**box and then press**Go**.

- From the available list, mark
**Solver Add-in**. - Then just press
**OK**.

Soon after, you will get the **Solver Add-in** available in the **Analyze **section of the **Data tab. **

Now we’ll insert the L.H.S (Left Hand Side) of the equations in column **C** and R.H.S (Right Hand Side) of the equation in column **D**. While inserting L.H.S, we’ll use the cell reference of the variables x,y, and z.

- For the first equation type
**=1*E10+2*E11-1*E12**in**Cell C10**.

- Insert
**=2*E10+1*E11+2*E12**in**Cell C11**.

- And write
**=3*E10+1*E11+4*E12**in**Cell C12**.

These formulas will return 0 as cells of x,y, and z are still empty, which means zero.

- After that, insert the constraints manually in column
**D**.

- Now it’s time to apply the
**Solver Add-in**. Click as follows:**Data > Solver**.

Soon you will get a dialog box like this named- **Solver Parameters**.

- From the
**Set Objective**box, click on the**Open icon**.

- Select
**Cell C10**and hit the**ENTER**button.

- Next, mark the
**Max**option and again click on the**open icon**from the**By Changing Variable Cells box**.

- Select the range from the variable column and press the
**ENTER**button.

At this moment we’ll add three subjects to the constraints.

- Click on the
**Add**button.

- For the first equation, select
**Cell C10**in the**Cell Reference**box, choose the**equal sign**from the drop-down list, and select**Cell D10**in the**Constraint box**. - Then just press
**OK**.

We are done with the first equation.

- Again press
**Add**button and do the same operations for the rest of the two equations. - Next, unmark the
**Make Unconstrained Variables Non-Negative**option and press**Solve**.

- Then from the
**Solver Results**dialog box, mark**Keep Solver Solution**and press**OK**.

Now take a look, we got the same output as our first method.

**Read More:** **How to Insert Equation in Excel (3 Easy Ways)**

**Conclusion**

That’s all for the article. I hope the procedures described above will be good enough to solve the system of equations in Excel. Feel free to ask any question in the comment section and please give me feedback.

## Related Articles

**Solve Differential Equation in Excel (With Easy Steps)****How to Solve Exponential Equation in Excel (4 Suitable Examples)****Solve Quadratic Equation in Excel VBA (with Quick Steps)****How to Solve 2 Equations with 2 Unknowns in Excel (2 Examples)****Solve an Equation for X When Y is Given in Excel****How to Solve Simultaneous Equations in Excel (3 Easy Ways)**