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
COUNT-LEADING	A1, [A2]	I	Returns number of consecutive times A2 appears at the beginning of A1
COUNT-TRAILING	A1, [A2]	I	Returns number of consecutive times A2 appears at the end of A1
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
INTERVAL-TIMER	None	N	Arbitrary time interval (in seconds)
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
TRIM	A1, [A2]	Z	Copy of A1 with all leading and trailing A2 trimmed
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.