Calculation operators in formulas

+

addition (arithmetic)

reference operators

combine ranges of cells for calculations

&

connects, or concatenates two values to produce one continuous value

/

division (arithmetic)

=

equal to (comparison)

^

exponentiation (arithmetic)

>

greater than (comparison)

>=

greater than or equal to (comparison)

<

less than (comparison)

<=

less than or equal to (comparison)

*

multiplication (arithmetic)

<>

not equal to (comparison)

%

percent (arithmetic)

:

range operator, produces one reference to all the cells between two references (reference)

-

subtraction/negation (arithmetic)

comparison operators

to compare two values; the result is a logical value; either TRUE or FALSE

arithmetic operator

to perform basic mathematical operations such as addition, subtraction or multiplication; to combine numbers

,

union operator, combines multiple references into one reference (reference)

text concatenation operator

use the ampersand (&) to join, or concatenate one or more text strings to produce a single piece of text