Excel Information Functions
FUNCTION | SYNTAX |
---|---|
CELL | CELL(info_type,reference) |
ERROR.TYPE | ERROR.TYPE(error_val) |
INFO | INFO(type_text) |
ISBLANK | ISBLANK(value) |
ISERR | ISERR(value) |
ISERROR | ISERROR(value) |
ISEVEN | ISEVEN(number) |
ISFORMULA | ISFORMULA(reference) |
ISLOGICAL | ISLOGICAL(value) |
ISNA | ISNA(value) |
ISNONTEXT | ISNONTEXT(value) |
ISNUMBER | ISNUMBER(value) |
ISODD | ISODD(value) |
ISREF | ISREF(value) |
ISTEXT | ISTEXT(value) |
N | N(value) |
NA | NA( ) |
SHEET | SHEET([value]) |
SHEETS | SHEETS([reference]) |
TYPE | TYPE(value) |