The following table lists the available operators. For each operator, an example is given of the syntax of using a literal value as well as a cell reference. The type of value returned is given for each type of operator.
Type of Operator | Example Syntax | Result | ||
---|---|---|---|---|
Operator | Description | Literal & Literal | Cell Ref & Literal | Type Returned |
Binary Operators | ||||
+ | Add | 5 + 3 | A1 + 3 | double |
– | Subtract | 5 – 3 | A1 – 3 | double |
* | Multiply | 5 * 3 | A1 * 3 | double |
/ | Divide | 5 / 3 | A1 / 3 | double |
^ | Exponent | 5 ^ 3 | A1 ^ 3 | double |
& | Concatenate | "F" & "p" | A1 & "p" | string |
= | Equal | A1 <> 3 | boolean | |
< > | Not Equal | A1 = 3 | boolean | |
< | Less Than | A1 <3 | boolean | |
> | Greater Than | A1 > 3 | boolean | |
<= | Less Than Or Equal | A1 <= 3 | boolean | |
>= | Greater Than Or Equal | A1 >= 3 | boolean | |
Unary Operators | ||||
- | Negate | -(5/3) | -(A1/3) | double |
+ | Plus | +(5/3) | +(A1/3) | double |
% | Percent | (5/3)% | (A1/3)% | double |
Operators specify the type of calculation that you want to perform on the elements of a formula. Most of the operators return double-precision floating point values for mathematical operations and boolean (or logical) values for comparison operators.
In Spread.Sheets, all arithmetic operators (including the unary +) check their arguments and return a #VALUE error if any of the arguments are strings that cannot be converted to a number. This is mathematically correct behavior and cannot be overridden. For example, the three formulas +B5 and 0+B5 and --B5 should all produce the same result and, in Spread.Sheets, they do.
For more information about operators, see Order of Precedence and Operators with Dates and Times.