Page 264 - open office
P. 264
Operator Description
: Reference operator (as in A2:A2 )
- Negation operator
,/ Multiplication, Division
& Text Concatenation
, ; Argument Separator
^ Exponent
,- Addition, Subtraction
>,<,>=,<=,<> Comparison operator
Mathematical Functions
These functions perform mathematical calculations on the specified arguments. Some mathematical
functions are:
Function Result (Considering a number as X)
It produces the sum of the numbers for a range of cells. E.g., SUM(C1 ...C4),
SUM( ...)
SUM(C1:C4) (will produce the addition of cells from C1 to C4)
ABS(X) It produces the positive (absolute) value of a given integer.
E.g., ABS(- ) , ABS(4) 4, ABS(-3. ) 3.
INT(X) It produces the integer value of a given integer.
E.g., I T(12.54) 12, I T(- . 2) -
S RT( ) It produces the square root of a positive integer.
E.g., S RT( ) 3, S RT(2) 1.414213562
ROU D( ) It produces the value of that is rounded to the number of digits specified by .
E.g., ROU D(12.234 2) 12.23, ROU D(32.6 ) 33
MOD( ) It produces the remainder of X divided by Y.
E.g., MOD(11 2) 1, MOD( 2)
POWER( ) It produces the value of X raised to the power of Y.
E.g., POWER(5 2) 25, POWER(-5 .5) UM!
264 Touchpad Information Technology-IX

