Solving Equations using Excel Solver

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.

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

Leave a Reply

Your email address will not be published. Required fields are marked *