Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

Spreadsheet: Operators

Arithmetic operators

The arithmetic operators, in order of precedence, are:

* /Multiplication, division
+ -Addition, subtraction

Relational operators

Relational operators compare two numbers or two strings. The result is a logical value expressed as a number, either 1 (=TRUE), or 0 (=FALSE). The relational operators, in order of precedence, are:

<Less than
>Greater than
<=Less than or equal to
>=Greater than or equal to

Order of operators

When arithmetic and relational operators are combined in one expression, the arithmetic are performed first. Use parentheses to change the order in which the operations are performed. Operations within parentheses are performed first.

See also