Solving equations using MS Excel 97 to 2003 versions

Home

Let us see how to solve the following equations using excel solver option in MS Excel 97 to 2003 versions.

12x+25y+687z=9

45x-24y+78z=12

567x+2y-7z=123

 

Solution:

  1. Open excel and go to tools

  2. See if there is an option called solver. By default this option will not be installed in excel.

  3. If the solver is not installed, go to tools, add-ins

  4. In add-in, select 'Solver' and click ok

  5. Insert the Microsoft office CD on demand.

 

  1. Now let us see how to solve the equation using solver.

          For this you need 3 columns A, B and C. (We need the result to appear in the column C (x, y and z in C1, C2 and C3 respectively)

 

 

 

 

 

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