Excel Information Formulas
Functions for testing cell type and content: checking for errors, empty values, and data types.
21 formulas
10 Beginner
10 Intermediate
1 Advanced
ISBLANK
Beginner
=ISBLANK(value)ISERROR
Beginner
=ISERROR(value)ISERR
Intermediate
=ISERR(value)ISNA
Beginner
=ISNA(value)ISTEXT
Beginner
=ISTEXT(value)ISNUMBER
Beginner
=ISNUMBER(value)ISNONTEXT
Beginner
=ISNONTEXT(value)ISLOGICAL
Beginner
=ISLOGICAL(value)ISEVEN
Beginner
=ISEVEN(number)ISODD
Beginner
=ISODD(number)ISREF
Intermediate
=ISREF(value)ISFORMULA
Intermediate
=ISFORMULA(reference)TYPE
Intermediate
=TYPE(value)N
Intermediate
=N(value)NA
Beginner
=NA()ERROR.TYPE
Intermediate
=ERROR.TYPE(error_val)CELL
Intermediate
=CELL(info_type, [reference])INFO
Intermediate
=INFO(type_text)SHEET
Intermediate
=SHEET([value])SHEETS
Intermediate
=SHEETS([reference])STOCKHISTORY
Advanced
=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], ...)