Solving equations using MS Excel

Home

Solving equations is very easy with excel. Let us see how to solve the following equations using excel solver tool.

12x+25y+687z=9

45x-24y+78z=12

567x+2y-7z=123

Solution:

  1. Open excel and go to Data tab

  2. Check whether there is a group by the name 'Analysis'. If it is there, then click Solver in the Analysis group as in the picture below.

  3. By default the 'Analysis' group will not be available in excel. If it is not available, then you need to load the Solver Add-in programme available for free in Excel.

  4. To load the Solver Add-in, Click the File tab, click Options, and then click the Add-Ins category.

  5.  

  6.  

  7. If you find it difficult, please visit the page How to load the Solver Add-in programme.

Now let us see how to solve the equations using solver tool.

For this let's choose 3 columns in Excel, for example A, B and C. We want the result to appear in the column C (the value of x, y and z should appear in the cells C1, C2 and  C3 respectively).

In A1 enter the formula                     12*C1+25*C2+687*C3

In A2 enter the formula                     45*C1-24*C2+78*C3

Similarly in A3 enter the formula      567*C1+2*C2-7*C3

Enter the values 9, 12 and 123 in B1, B2 and B3 respectively.

Now open solver.

Enter the destination range in the box 'By changing variable cells' (select C1, C2 and C3 by dragging)

Enter the constraints inside the box 'Subject to the Constraints' by clicking the 'Add' button as below.

Now click 'Add' and insert the next 2 constraints.

Unselect the check-box 'Make Unconstrained Variables Non-Negative' and click Solve.

Now you get the solution of these equations in the cells C1, C2 and C3.

For more details, visit MS Office website

If you are using MS Excel versions 97-2003, please click here.

 

Search engine keywords for this question
Solving difficult equations using Excel 2007, 2010, 2013, 2016
How to solve three variable equation?
Solving equations having multiple variables
How to solve complex equations using Microsoft Office Excel