Information Functions¶

Type Checking¶

Function	Syntax	Example	Description
ISBLANK	`ISBLANK(value)`	`=ISBLANK(A1)`	TRUE if cell is empty
ISNUMBER	`ISNUMBER(value)`	`=ISNUMBER(A1)`	TRUE if value is a number
ISTEXT	`ISTEXT(value)`	`=ISTEXT(A1)`	TRUE if value is text
ISLOGICAL	`ISLOGICAL(value)`	`=ISLOGICAL(TRUE)`	TRUE if value is TRUE/FALSE
ISFORMULA	`ISFORMULA(reference)`	`=ISFORMULA(A1)`	TRUE if cell contains a formula
ISEVEN	`ISEVEN(number)`	`=ISEVEN(4)`	TRUE if number is even
ISODD	`ISODD(number)`	`=ISODD(3)`	TRUE if number is odd

Function	Syntax	Example	Description
ISERROR	`ISERROR(value)`	`=ISERROR(A1/0)`	TRUE if value is any error
ISNA	`ISNA(value)`	`=ISNA(VLOOKUP(...))`	TRUE if value is #N/A
ERROR.TYPE	`ERROR.TYPE(value)`	`=ERROR.TYPE(A1)`	Returns error type number (1=#NULL!, 2=#DIV/0!, etc.)
NA	`NA()`	`=NA()`	Returns the #N/A error value

Function	Syntax	Example	Description
TYPE	`TYPE(value)`	`=TYPE(A1)`	Returns type code: 1=number, 2=text, 4=logical, 16=error
N	`N(value)`	`=N(TRUE)`	Converts value to number (TRUE=1, text=0)
CELL	`CELL(info_type, reference)`	`=CELL("col", A1)`	Returns info about a cell (col, row, address, etc.)
INFO	`INFO(type_text)`	`=INFO("osversion")`	Returns system information
SHEET	`SHEET([reference])`	`=SHEET()`	Returns sheet number of current or referenced sheet