How to Solve Linear Equations With Excel
- 1). Open your user account in Windows XP/Vista and launch Microsoft Excel. Press "Ctrl-N" on the keyboard to create a new Excel worksheet.
- 2). Click on the cell "A3" in the worksheet and press the key "=" on the keyboard. Type the following string "A1*B2-A2*B1" and press "Enter."
- 3). Click on the cell "B3" and press the key "=" on the keyboard. Type the following string "C1*B2-C2*B1" and press "Enter."
- 4). Click on the cell "C3" and press the key "=" on the keyboard. Type the following string "A1*C2-A2*C1" and press "Enter."
- 5). Click on the cell "A4" and press the key "=" on the keyboard. Type the expression "B3/A3" and press "Enter."
- 6). Click on the cell "C4" and press the key "=" on the keyboard. Type the expression"C3/A3" and press "Enter."
- 7). Press "Ctrl-S." Type a descriptive file name, for example and press "Save" for saving the file on your computer.
- 1). Open Microsoft Excel and press "Ctrl-O." Browse your computer and open the file created in Section 1.
- 2). Enter the coefficients of the first equation ("a1" "b1" and "c1") in the cells "A1," "B1," and "C1" of the file. In this example, type "-2" "7" and "15" in those cells.
- 3). Enter the coefficients of the second equation ("a2" "b2" and "c2") in the cells "A2," "B2," and "C2" of the file. For this example, type "3" "12" and "-4" in those cells.
- 4). Read the equation solution that becomes available instantly. The values of the variables "X" and "Y" will be displayed in the cell "A4" and "C4" respectively. In this example, "X" = -4.622 and "Y"= 0.822.