14.9 Miscellaneous functions
The following functions perform a wide range of tasks:
-
ALERT(
message,
button1
{, button2} )
-
COL(
{cell_reference or range} )
-
COLS(
{array or range}} )
-
COMMAND(
text )
-
CURRENT_CELL( )
-
DEREF(
cell_reference )
-
DOUBLECLICK( )
-
FLIP(
data )
-
IF(
condition,
then-expression,
else-expression )
-
INDEX(
data,
col,
row
{, cols,
rows} )
-
INPUT(
message,
name,
button1
{, button2} )
-
ISBLANK(
value )
-
ISERR(
value )
-
ISERROR(
value )
-
ISEVEN(
number )
-
ISLOGICAL(
value )
-
ISNA(
value )
-
ISNONTEXT(
value )
-
ISNUMBER(
value )
-
ISODD(
number )
-
ISREF(
value )
-
ISTEXT(
value )
-
N(
value )
-
PAGE(
cell_reference
{, type} )
-
PAGES(
{direction} )
-
ROW(
{cell_reference or range} )
-
ROWS(
{array or range} )
-
SET_NAME(
name,
expression )
-
SET_VALUE(
destination,
source )
-
SORT(
data,
column_index )
-
TYPE(
expression )
-
VERSION( )