Navigation:  Formula Reference > Formula OverView >

Operators in a Formula

Previous pageReturn to chapter overviewNext page

 

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.