Excel Operators
Check out our collection of Excel Operators below. For more information on any of the operators, just click on the operator name!
Categories
Arithmetic Operators
Operator
Symbol
Objective
Preview
Addition 🔗
+
Add numbers together within a formula
=A1 + B1
-
Subtract numbers together within a formula
=A1 - B1
*
Multiply numbers together within a formula
=A1 * B1
Division 🔗
/
Divide numbers together within a formula
=A1 / B1
Raise a number to a power
=A1 ^ B1
Comparison Operators
Operator
Symbol
Objective
Preview
<> or !=
Check if two cells are not identical
=A1 <> B1 or =A1 != B1
>
Check if a value is greater than another value
=A1 > B1
Check if a value is less than or equal to another value
=A1 <= B1
^
Check if two cells are identical
=A1 = B1
<
Check if a value is less than another value
=A1 < B1
<=
>=
Check if a value is greater than or equal to another value
=A1 >= B1
Objective
Preview
Join two or more text strings
=”Cat” & “ “ & “Dog”
Reference Operators
Objective
Preview
=
Equal to 🔗
Text Concatenation Operators
+
Symbol
Operator
Define a range of cells
=A1:B10
Create a union of ranges
=A1:B10 C1:D10
-
Symbol
Operator
&
:
Colon 🔗
Range Union Operators
Objective
Preview
Unary Operators
Objective
Preview
Indicate a negative value and change the sign of a numeric value to negative
=-A1
Indicate a positive value but does not change the actual value
=+A1
Symbol
Operator
Space 🔗