Creating Formulas

When using formulas in Excel you can add, subtract, multiply, and divide. Use Excel formulas to also make cell references in Excel.

Creating formulas

In school, you may have had to memorize certain formulas to work math problems. Microsoft Excel uses formulas to perform calculations within a spreadsheet. In this lesson, you will learn how to use Excel’s formula features.

Addition+
Subtraction-
Multiplication*
Division/
Exponentiation (to the power of)^
Precedence (do this first)(put in parentheses)
Equal to=
Not equal to< >
Greater than>
Less than<