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

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

## EXP

Syntax:EXP( number )

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

## 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 between TRUE and FALSE 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 between TRUE and FALSE 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.

Previous
Next