Arithmetic operator
|
Meaning
|
Example
|
+ (plus sign)
|
Addition
|
3+3
|
– (minus sign)
|
Subtraction
Negation |
3–1
–1 |
* (asterisk)
|
Multiplication
|
3*3
|
/ (forward slash)
|
Division
|
3/3
|
% (percent sign)
|
Percent
|
20%
|
^ (caret)
|
Exponentiation
|
3^2
|
Comparison operator
|
Meaning
|
Example
|
= (equal sign)
|
Equal to
|
A1=B1
|
> (greater than sign)
|
Greater than
|
A1>B1
|
< (less than sign)
|
Less than
|
A1<B1
|
>= (greater than or equal to sign)
|
Greater than or equal to
|
A1>=B1
|
<= (less than or equal to sign)
|
Less than or equal to
|
A1<=B1
|
<> (not equal to sign)
|
Not equal to
|
A1<>B1
|
Text operator
|
Meaning
|
Example
|
& (ampersand)
|
Connects, or concatenates, two values to produce one continuous text value
|
("North"&"wind")
|
Reference operator
|
Meaning
|
Example
|
: (colon)
|
Range operator, which produces one reference to all the cells between two references, including the two references
|
B5:B15
|
, (comma)
|
Union operator, which combines multiple references into one reference
|
SUM(B5:B15,D5:D15)
|
(space)
|
Intersection operator, which produces on reference to cells common to the two references
|
| Data type | Length | Description |
|---|---|---|
| BYTE | 1 byte | Number from 0 to 255 for storing binary data |
| INTEGER | 2 | Integer from -32 768 to 32 767. |
| LONG | 4 | Integer from -2 147 483 648 to 2 147 483 647 |
| SINGLE | 4 | Numeric data type with float precision to 6 decimal digits |
| DOUBLE | 8 | Numeric data type with float precision with double precision in calculatons |
| CURRENCY | 8 | A number with fixed 4 decimal digits |
| DECIMAL | 14 | Numeric data type with fixed precision and scale (precision 28). |
| STRING | Text strings. Flexible lenght or 64 kilobytes | |
| BOOLEAN | 2 | Logical value (true or false) |
| DATE | 8 | The date in range from 1.1.100 to 31.12.9999 |
| OBJECT | 4 | Reference to an object. |
| VARIANT | 16 | Basic type. May contain special value Null, any numeric value, text, reference to object or variable array. |
