Solving equations using Excel
Solving equations is very easy with excel. Let us see how to solve the following equations using excel solver option.
12x+25y+687z=9
45x-24y+78z=12
567x+2y-7z=123
Solution:
Go to Data tab, select Analysis group, click Solver.
If Solver command or Analysis group is not available, Solver Add-in needs to be installed
To install the add in , click Microsoft Office Button , go to Excel Options, and then click the Add ins category.
The following needs to be followed for older versions of MS Excel
Open excel and go to tools
See if there is an option called solver. By default this option will not be installed in excel.
If the solver is not installed, go to tools, add-ins
In add-in, select 'Solver' and click ok
Insert the Microsoft office CD on demand.
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)
In A1 enter the formula 12*C1+25*C2+687*C3
Similarly 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 from tools menu
Clear the contents of 'set target cell'
In 'by changing cell', select C1, C2 and C3 by dragging
In 'subject to constraints', click add
For 'cell reference' select data range A1, A2, A3
In the middle column, select '=' simbol
In the constraint, select data range B1, B2, B3
Click OK
Now the solver parameters look like this
Click solve on the solver window
Click OK on the next window.
Now you get the solution the these equations in the cells C1, C2 and C3.