Mathematical functions

ABSABS

Syntax:ABS( number )

Returns the absolute value of number.

ACOSACOS

Syntax:ACOS( number )

Returns the arccosine of number in radians.

ASINASIN

Syntax:ASIN( number )

Returns the arcsine of number in radians.

ATANATAN

Syntax:ATAN( number )

Returns the arctangent of number in radians.

ATAN2ATAN2

Syntax:ATAN2( x, y )

Returns the arctangent in radians for the specified coordinates x and y.

CEILINGCEILING

Syntax:CEILING( number )

Rounds the value up to the nearest integer.

COMPARECOMPARE

Syntax:COMPARE( left, right, epsilon )

Returns:

• 0 if left and right differs by not more than epsilon.
• -1 if left is less than right by more than epsilon.
• 1 if left is greater than right by more than epsilon.

COSCOS

Syntax:COS( number )

Returns the cosine of number in radians.

COTCOT

Syntax:COT( number )

Returns the cotangent of number in radians.

DEGREESDEGREES

Syntax:DEGREES( radians )

Converts radians to degrees.

DIVDIV

Syntax:DIV( number_1, number_2 )

Divides number_1 by number_2. The result is rounded down to the nearest integer.

DIV_SAFEDIV_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.

EXPEXP

Syntax:EXP( number )

Returns the result of raising the number 'e' to the power of number.

FDIV_SAFEFDIV_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.

FLOORFLOOR

Syntax:FLOOR( number )

Rounds the value down to the nearest integer.

GREATESTGREATEST

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 between TRUE and FALSE for Boolean type.

LEASTLEAST

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 between TRUE and FALSE for Boolean type.

LNLN

Syntax:LN( number )

Returns the natural logarithm of the number number. Returns NULL if the number is less than or equal to 0.

LOGLOG

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.

LOG10LOG10

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.

PIPI

Syntax:PI()

Returns PI. The accuracy depends on the data source.

POWERPOWER

Syntax:POWER( base, power )

Raises base to the power of power.

RADIANSRADIANS

Syntax:RADIANS( degrees )

Converts degrees degrees to radians.

ROUNDROUND

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.

SIGNSIGN

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.

SINSIN

Syntax:SIN( number )

Returns the sine of number in radians.

SQRTSQRT

Syntax:SQRT( number )

Returns the square root of the specified number.

SQUARESQUARE

Syntax:SQUARE( number )

Returns the number number raised to the power of 2.

TANTAN

Syntax:TAN( number )

Returns the tangent of number in radians.