Mathematical Operators

Mathematical Operators that can be used in Microsoft Excel

The following is a list of mathematical operators that you can use in your formulas:

OperatorDescriptionExplanation & Example
+AdditionUse the "plus" sign when adding numbers within your formula.

-SubtractionUse the "minus" sign when subtracting numbers within your formula.

*MultiplicationUse the "asterisk" symbol when multiplying numbers within your formula.

/DivisionUse the "forward slash" symbol when dividing numbers within your formula.

^Exponent (to the power of)The "caret" symbol is used when you're using exponents within your formulas.

-Negative valuesUsing the "minus" sign in front of a number converts the number into a negative value.

ABS( )Absolute valuesRemoves the sign associated with a number. If you use the ABS( ) function on a negative number, it will treat the number as a positive value (ignoring the negative).

( )ParenthesesUsing parentheses within your formulas controls the order of operations when Microsoft Excel calculates your formula.

* Read about Order of Operations


Go back to Excel Tutorials.