How to Do Algebra in Excel

Excel can help make algebraic equations easier to solve, but it will not completely solve them for you.
••• Comstock/Comstock/Getty Images

Microsoft Excel can be a very useful program. Excel can be used as a tool to help with algebraic equations; however, the program will not complete the equations on its own. You must put the information into Excel and let it come up with the answer. Additionally, it is imperative that all formulas and equations are entered into Excel correctly or you may receive an error message or an incorrect answer to your algebra problem. It is important to remember that all equations begin with an equals sign.

Division Equations

    Enter the different values for your equation into separate cells on your Excel spreadsheet. Placing the different values in cells in a row either horizontally or vertically will help to keep your equations straight.

    Enter the appropriate formula for the equation you are attempting to solve. For example, if you are trying to solve an equation like 500x=6000 for x, you must divide 6000 by 500. Therefore you would enter 500 into cell A1, enter 6000 into cell B1 and enter “=B1/A1” into cell C1.

    Press enter to bring up the answer in cell C1. The formal can be filled down if you have multiple similar algebra problems by clicking on the first cell with the formula, dragging and highlighting all the cells where you would like to have the formula, and clicking the fill button.

Multiplication Equations

    Enter the different values for your equation into separate cells on your Excel spreadsheet. Placing the different values in cells in a row either horizontally or vertically will help to keep your equations straight.

    Enter the appropriate formula for the equation you are attempting to solve. For example, if you are trying to solve an equation like x=7a+2b for x and you are given the values for a and b, a formula can easily be created. Type the value of a in cell A1, type the value of b in cell B1 and type “=(7_A1)+(2_B1)” into cell C1.

    Press enter to bring up the answer in cell C1. The formal can be filled down if you have multiple, similar algebra problems by clicking on the first cell with the formula, dragging and highlighting all the cells where you would like to have the formula, and clicking the fill button.

Related Articles

How to Solve Linear Programming in Excel
How to Remove Duplicates in Two Rows in OpenOffice
How to Store & Access Equations on a TI-83 Plus
How to Subtract Matrices on Excel
How to Find Zeros of Functions in Excel
How to Calculate Correlation Coefficient Between Two...
How to Solve by Simpson's Rule With Excel
How to Solve a Quadratic Equation With a Casio Calculator
How to Create Matrices on a TI-89
How to Draw an Array in Math
How to Solve 3-Variable Linear Equations on a TI-84
How to Calculate the Percent Change in Excel
What Does ##### Mean in Excel?
How to Find the Intersection of Two Linear Equations
How to Convert CM to Inches in Excel
How to Write Notes on a TI-84 Silver Edition Calculator
How to Factor on a TI 84 Plus
How to Calculate Pearson's R (Pearson Correlations)...
How to Graph a Distribution for a T-Test
Instructions for a Casio MS 80

Dont Go!

We Have More Great Sciencing Articles!