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.

=(1+1)=2
-SubtractionUse the "minus" sign when subtracting numbers within your formula.

=(1-1)=0
*MultiplicationUse the "asterisk" symbol when multiplying numbers within your formula.

=(2*3)=6
/DivisionUse the "forward slash" symbol when dividing numbers within your formula.

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

=(2^3)=8
-Negative valuesUsing the "minus" sign in front of a number converts the number into a negative value.

=(-2)=-2
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).

=abs(-2)=2
( )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.