Functions Information Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/information-functions.md Ask Claude about this pageOpens Claude with this page's address Ask what a cell holds: type, emptiness, errors. FunctionWhat it does CELL Information about a cell's formatting, location or contents. ERROR.TYPE Returns number corresponding to an error type. FORMULATEXT Returns formula as a text string. INFO Information about the operating environment. ISBLANK Returns TRUE if value is blank. ISDATE True when a value can be read as a date. ISEMAIL True when text looks like an email address. ISERR Returns TRUE if value is any error except #N/A. ISERROR Returns TRUE if value is any error. ISEVEN Returns TRUE if number is even. ISFORMULA Returns TRUE if cell contains a formula. ISLOGICAL Returns TRUE if value is logical. ISNA Returns TRUE if value is #N/A error. ISNONTEXT Returns TRUE if value is not text. ISNUMBER Returns TRUE if value is a number. ISODD Returns TRUE if number is odd. ISREF Returns TRUE if value is a reference. ISTEXT Returns TRUE if value is text. ISURL True when text looks like a url. N Converts a value to a number. NA Returns the error value #N/A. SHEET Returns sheet number of a reference. SHEETS Number of sheets in a reference. TYPE Returns type of a value as number.
