The following table 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
|
| ACOS
| N1
| N
| Arccosine of N1
|
| ANNUITY
| N1, N2
| N
| Ratio of annuity paid for I2 periods at interest 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 |