Juniper Systems Allegro CX Manual - Manual (Page 164)

164 Allegro CX Owner’s Manual
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.
Lookup(value, vector1, vector2)
Finds the value in a row or column (vector1) and returns the
corresponding value from a row or column (vector2).
Match(lookupValue, lookupRange, matchType)
Returns the position of an item in a range that matches a specifi ed
value in a specifi ed 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).
Offset(reference, rows, cols, height, width)
Returns a reference to a range shifted by specifi ed number of rows
and columns.
Row(reference)
Returns the row number of the given reference.