



Table 52provides an overview of the argument type, function type and value returned for each of the intrinsic functions. Argument types and function types are abbreviated as follows:
| Table 52. Table of Functions | |||
| Function Name | Arguments | Type | Value Returned |
|---|---|---|---|
| ACOS | N1 | N | Arccosine of N1 |
| ANNUITY |
N1, I2 |
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 |
| DAY-OF-INTEGER ( |
I1 |
I |
Julian date equivalent (YYYYDDD) |
| 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, 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 | X | Value of maximum argument; note that the type of function depends on the arguments |
| I1... or | I | ||
| N1... or | N | ||
| X1... | X | ||
| MEAN | N1... | N | Arithmetic mean of arguments |
| MEDIAN | N1... | N | Median of arguments |
| MIDRANGE |
N1... |
N |
Mean of minimum and maximum arguments |
| MIN |
A1... or | X | Value of minimum argument; note that the type of function depends on the arguments |
| I1... or | I | ||
| N1... or | N | ||
| X1... | X | ||
| MOD | I1,I2 | I | I1 modulo I2 |
| NUMVAL |
X1 |
N |
Numeric value of simple numeric string |
| NUMVAL-C |
X1 or 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..., N1..., or X1... |
I |
Ordinal position of maximum argument |
| ORD-MIN |
A1..., N1..., or X1... |
I |
Ordinal position of minimum argument |
| PRESENT-VALUE |
N1 or N2... |
N |
Present value of a series of future period-end amounts, N2, at a discount rate of N1 |
| RANDOM | I1, none | N | Random number |
| RANGE |
I1... or | I | Value of maximum argument minus value of minimum argument; note that the type of function depends on the arguments. |
| N1... |
N |
||
| 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 | I | Sum of arguments; note that the type of function depends on the arguments. |
| N1... | N | ||
| 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 arguments |
| WHEN-COMPILED |
None |
X |
Date and time when program was compiled |
The following topics define each of the Intrinsic Functions summarized in the previous table.
© Copyright IBM Corp. 1991, 1998
Adobe, the Adobe logo, Acrobat, the Acrobat logo, and Acrobat Reader are registered trademarks of Adobe Systems incorporated.