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.
Adobe, the Adobe logo, Acrobat, the Acrobat logo, and Acrobat Reader are registered trademarks of Adobe Systems incorporated.