Operators are symbols used for four arithmetic operations, cell references.
Types of Operators
Four major types exist.
- Arithmetic operators
- String concatenation operators
- Comparison operators
- Reference operators
The arithmetic operators and string concatenation operators are easy for beginners to use and have a wide range of applications.
Comparison operators also have a wide range of uses, but require some getting used to.
Reference operators are rarely used consciously, but they can be useful if you remember their existence.
|-||Function||Formula Example.||Result of the formula example.|
The FILTER function uses + as a logical OR and * as a logical product.
String concatenation operators
|-||Formula Example.||Result of the formula example.|
|=||The left and right sides are equal.||A1=B1|
|>||Left side is greater than right side.||A1>B1|
|<||Left side is less than right side.||A1<B1|
|>=||Left side is greater than or equal to right side||A1>=B1|
|<=||Left side is less than or equal to right side||A1<=B1|
|<>||The left and right sides are not equal.||A1<>B1|
These are operators that are rarely specified consciously.
They are often specified automatically by mouse operation.
|:||Multiple adjacent cells.||A5:A15|
|,||Multiple non-adjacent cells.||A5:A15,C5:E15|
|Whitespace characters. Multiple overlapping ranges.||B7:D7 C6:C8|