higher math functions
Function:
ABS
Function Name:
Absolute value
Syntax:
ABS(n)
Description:
Returns the absolute value of the argument. If n < 0, returns (-n), if n >= 0, returns n.
Example Usage:
ABS(-5)
Return Value:
5
Function:
CEILING
Function Name:
Ceiling
Syntax:
CEILING(n)
Description:
Returns the ceiling of a given value. The ceiling is the next integer value larger than the fractional argument. If an integer value is specified as the argument to CEILING, the return value will equal the argument.
Example Usage:
CEILING(1.2)
Return Value:
2
Function:
EXP
Function Name:
e to the power of n
Syntax:
EXP(n)
Description:
Returns e, the natural number, raised to the power of n
Example Usage:
EXP(1)
Return Value:
2.718281828
Function:
FLOOR
Function Name:
Floor
Syntax:
FLOOR(n)
Description:
Returns the floor of a value. The floor is the next integer value smaller than the fractional argument. If an integer value is specified as the argument to FLOOR, the return value will equal the argument.
Example Usage:
FLOOR(5.9)
Return Value:
5
Function:
LOG
Function Name:
Logarithm
Syntax:
LOG(n)
Description:
Returns the base-10 logarithm of the given value.
Example Usage:
LOG(2)
Return Value:
0.3010299957
Function:
LN
Function Name:
Natural log
Syntax:
LN(n)
Description:
Returns the natural log of a value.
Example Usage:
LN(2)
Return Value:
0.6931471806
Function:
SIGN
Function Name:
Sign function
Syntax:
SIGN(n)
Description:
Returns the sign of the argument – returns –1 if n<0, 0 if x=0, +1 if x>0.
Example Usage:
SIGN(-9)
Return Value:
-1
Function:
SQRT
Function Name:
Square root
Syntax:
SQRT(n)
Description:
Returns the square root of the argument.
Example Usage:
SQRT(625)
Return Value:
25
Function:
ROOT
Function Name:
Root function
Syntax:
ROOT(x, n)
Description:
Returns the nth root of x.
Example Usage:
ROOT(27, 3)
Return Value:
3
Function:
ROUNDED
Function Name:
Round function
Syntax:
ROUNDED(n) or COMPUTE x ROUNDED = n.
Description:
Rounds the argument to the nearest integer, with a decimal value of .5 rounding to the next highest integer.
Example Usage (1):
COMPUTE x ROUNDED = 1.5.
Return Value (1):
2
Example Usage (2):
ROUNDED(1.49999)
Return Value (2):
1