Mathematical functions
ABS
Syntax:ABS( number )
Returns the absolute value of number
.
ACOS
Syntax:ACOS( number )
Returns the arccosine of number
in radians.
ASIN
Syntax:ASIN( number )
Returns the arcsine of number
in radians.
ATAN
Syntax:ATAN( number )
Returns the arctangent of number
in radians.
ATAN2
Syntax:ATAN2( x, y )
Returns the arctangent in radians for the specified coordinates x
and y
.
CEILING
Syntax:CEILING( number )
Rounds the value up to the nearest integer.
COMPARE
Syntax:COMPARE( left, right, epsilon )
Returns:
- 0 if
left
andright
differs by not more thanepsilon
. - -1 if
left
is less thanright
by more thanepsilon
. - 1 if
left
is greater thanright
by more thanepsilon
.
COS
Syntax:COS( number )
Returns the cosine of number
in radians.
COT
Syntax:COT( number )
Returns the cotangent of number
in radians.
DEGREES
Syntax:DEGREES( radians )
Converts radians to degrees.
DIV
Syntax:DIV( number_1, number_2 )
Divides number_1
by number_2
. The result is rounded down to the nearest integer.
DIV_SAFE
Syntax:DIV_SAFE( numerator, denominator [ , fallback_value ] )
Divides numerator
by denominator
. Returns fallback_value
if division by zero occurs. If the number fallback_value
is omitted, it is assumed to be NULL
.
The result is rounded down to the nearest integer.
EXP
Syntax:EXP( number )
Returns the result of raising the number 'e' to the power of number
.
FDIV_SAFE
Syntax:FDIV_SAFE( numerator, denominator [ , fallback_value ] )
Divides numerator
by denominator
. Returns fallback_value
if division by zero occurs. If the number fallback_value
is omitted, it is assumed to be NULL
.
FLOOR
Syntax:FLOOR( number )
Rounds the value down to the nearest integer.
GREATEST
Syntax:GREATEST( value_1, value_2, value_3 [ , ... ] )
Returns the greatest value.
See also LEAST.
Depending on the specified data type, it returns:
- The greatest number.
- The last string in alphabetical order.
- The latest date.
TRUE
when selecting betweenTRUE
andFALSE
for Boolean type.
LEAST
Syntax:LEAST( value_1, value_2, value_3 [ , ... ] )
Returns the smallest value.
See also GREATEST.
Depending on the specified data type, it returns:
- The smallest number.
- The first string in alphabetical order.
- The earliest date.
FALSE
when selecting betweenTRUE
andFALSE
for Boolean type.
LN
Syntax:LN( number )
Returns the natural logarithm of the number number
. Returns NULL
if the number is less than or equal to 0.
LOG
Syntax:LOG( value, base )
Returns the logarithm of value
to base base
. Returns NULL
if the number value
is less than or equal to 0.
LOG10
Syntax:LOG10( number )
Returns the logarithm of the number number
to base 10. Returns NULL
if the number is less than or equal to 0.
PI
Syntax:PI()
Returns PI. The accuracy depends on the data source.
POWER
Syntax:POWER( base, power )
Raises base
to the power of power
.
RADIANS
Syntax:RADIANS( degrees )
Converts degrees
degrees to radians.
ROUND
Syntax:ROUND( number [ , precision ] )
Rounds the number number
to the number of decimal digits specified in precision
.
If the number precision
is omitted, number
is rounded to the nearest integer.
SIGN
Syntax:SIGN( number )
Returns the sign of the number number
:
-1
if the number is negative.
0
if the number is zero.1
if the number is positive.
SIN
Syntax:SIN( number )
Returns the sine of number
in radians.
SQRT
Syntax:SQRT( number )
Returns the square root of the specified number.
SQUARE
Syntax:SQUARE( number )
Returns the number number
raised to the power of 2.
TAN
Syntax:TAN( number )
Returns the tangent of number
in radians.