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.

  • B6<5+3 returns 1 if the contents of B6 is less than 8, otherwise this expression returns 0.
  • 5+3*(A1>3) returns 8 if cell A1 contains a value greater than 3 (since A1>3 = TRUE = 1). If A1 contains 3 or a number less than 3, this expression returns 5 (A1>3 = FALSE = 0).

See also

Share on Facebook Share on Twitter

This site uses cookies to store information on your computer. More info...