Juniper Systems Allegro DOS Manual - Manual (Page 141)

Windows CE Page 4-75
IsErr(value) Returns TRUE if the value is any error value except !!NA.
IsError(value) Returns TRUE if the value is any error value.
IsLogical(value) Returns TRUE if the value is a logical value.
IsNA(value) Returns TRUE if the value is error value !!NA.
IsNonText(value) Returns TRUE if value is any value that is not text.
IsNumber(value) Returns TRUE if the value is a number.
IsRef(value) Returns TRUE if the value refers to a reference.
IsText(value) Returns TRUE if the value is text.
Match(lookupValue, lookupRange, matchType) Returns the position of an
item in a range that matches a specified value in a specified order.
LookupValue is the value you want to match in the range.
N(value) Returns a value converted to a number.
NA() Returns the error value !!NA (no value is available).
Row(reference) Returns the row number of the given reference.
Rows(range) Returns the number of rows in a reference or array.
Example: Rows(A1:A5) equals 5.
VLookup(lookupValue, data, column) Searches for a value in the leftmost
column of a data table, and then returns a value in the same row from a
column you specify. LookupValue is the value to be found in the first
column of the data table. Data is the table of data. Column is the column
number in the data table from which the matching value is returned.
Database Functions
Daverage(database, field, criteria) Averages the values in the specified
database column matching the conditions.
Dcount(database, field, criteria) Counts the cells containing numbers in the
specified database column matching the conditions.
Dcounta(database, field, criteria) Counts nonblank cells in the specified
database column matching the conditions.
Dget(database, field, criteria) Extracts a single value from the specified
database column matching the conditions.
Dmax(database, field, criteria) Returns the largest number in the specified
database column matching the conditions.
Dmin(database, field, criteria) Returns the smallest number in the specified
database column matching the conditions.
Dproduct(database, field, criteria) Multiplies the values in the specified
database column matching the conditions.