Juniper Systems Allegro CX Manual - Manual (Page 163)

Allegro CX Owner’s Manual 163
T(value)
Returns the text referred to by value.
Example: A1 contains “AAA” then T(A1) equals “AAA”.
Trim(text)
Removes all spaces from a text string except for single spaces
between words.
Upper(text)
Converts text to uppercase.
Example: Upper(“Allegro FPC”) equals ALLEGRO FPC.
Value(text)
Converts a text that represents a number to the number.
Example: Value(“1000”) equals 1000.
Information & Lookup Functions
Address(row, col, refType, A1, sheetName)
Creates a cell reference from specifi ed row and column numbers.
Column(reference)
Returns the column number of the given reference.
Columns(range)
Returns the number of columns in an array or reference.
Example: Columns(A1:D1) equals 4.
HLookup(lookupValue, data, row)
Searches for a value in the top row of a data table and then returns
a value in the same column from a row you specify. LookupValue
is the value to be found in the fi rst row of the data table. Data is the
table of data. Row is the row number in the data table from which
the matching value is returned.
Index(range, rowNum, colNum)
Returns a reference to a specifi ed cell within range.
Indirect(text)
Returns the reference specifi ed by a text.
IsBlank(value)
Returns TRUE if the value is blank.