Juniper-systems Allegro CX Manual Manual do Utilizador descarregar pdf (Página 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 speciﬁ ed

value in a speciﬁ 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 speciﬁ ed number of rows

and columns.

Row(reference)

Returns the row number of the given reference.

1 2 ... 159 160 161 162 163 164 165 166 167 168 169 ... 303 304

Sem comentários

Juniper-systems Allegro CX Manual Manual do Utilizador Página 164