Function Definitions

The table below summarizes the functions that are now available.

The Arguments column defines the type and number of arguments as follows:

A alphabetic
I integer
N numeric
X alphanumeric

The Type column defines the type of the function as follows:

I integer
N numeric
Z alphanumeric
Function-name Arguments Type Value returned
ABSOLUTE-VALUE (or ABS) N1 N Absolute value of the argument passed
ACOS N1 N Arccosine of N1
ANNUITY N1, N2 N Ratio of annuity paid for I2 N2 periods at interest rate of N1 to initial investment of one
ASIN N1 N Arcsine of N1
ATAN N1 N Arctangent of N1
CHAR I1 X Character in position I1 of program collating sequence
COS N1 N Cosine of N1
CURRENT-DATE None X Current date and time and difference from Greenwich Mean Time
DATE-OF-INTEGER I1 I Standard date equivalent (YYYYMMDD) of integer date
DAY-OF-INTEGER I1 I Julian date equivalent (YYYYDDD) of integer date
FACTORIAL I1 I Factorial of I1
INTEGER N1 I The greatest integer not greater than N1
INTEGER-OF-DATE I1 I Integer date equivalent of standard date (YYYYMMDD)
INTEGER-OF-DAY I1 I Integer date equivalent of Julian date (YYYYDDD)
INTEGER-PART N1 I Integer part of N1
LENGTH A1 or N1 or X1 I Length of argument
LOG N1 N Natural logarithm of N1
LOG10 N1 N Logarithm to base 10 of N1
LOWER-CASE A1 or X1 X All letters in the argument are set to lowercase
MAX A1... or I1... or N1... or X1... Depends on arguments* Value of maximum argument
MEAN N1... N Arithmetic mean of arguments
MEDIAN N1... N Median of arguments
MIDRANGE N1... N Mean of minimum and maximum arguments
MIN Al... or I1... or N1... or X1... Depends on arguments* Value of minimum argument
MOD I1, I2 I I1 modulo I2
NUMVAL X1 N Numeric value of simple numeric string
NUMVAL-C X1, X2 N Numeric value of numeric string with optional commas and currency sign
ORD A1 or X1 I Ordinal position of the argument in collating sequence
ORD-MAX A1... or N1... or X1... I Ordinal position of maximum argument
ORD-MIN A1... or N1... or X1 I Ordinal position of minimum argument
PRESENT-VALUE N1, N2... N Present value of a series of future period-end amounts, N2n at a discount rate of N1
RANDOM I1 N Random number
RANGE I1... or N1... Depends on arguments Value of maximum argument minus value of minimum argument
REM N1, N2 N Remainder of N1/N2
REVERSE A1 or X1 X Reverse order of the characters of the argument
SIN N1 N Sine of N1
SQRT N1 N Square root of N1
STANDARD-

DEVIATION

N1... N Standard deviation of arguments
SUM I1... or N1... Depends on arguments Sum of arguments
TAN N1 N Tangent of N1
UPPER-CASE A1 or X1 X All letters in the argument are set to uppercase
VARIANCE N1... N Variance of argument
WHEN-COMPILED None X Date and time program was compiled

*A function that has only alphabetic arguments is type alphanumeric.