Practice free

Information functions

Information functions tell you what is in a cell: a number, text, an error or nothing at all. They are most useful as checks inside other formulas.

21 functions in this category.

Start here

All information functions

FunctionWhat it doesLevelSinceSpills?
CELL Reports facts about a cell such as its address, column, or the workbook path. Advanced 2007 or earlier No
ERROR.TYPE Turns an error into a code so formulas can respond to a specific kind of error. Advanced 2007 or earlier No
INFO Tells you about the operating environment, such as the calculation mode. Expert 2007 or earlier No
ISBLANK Checks whether a cell has nothing in it. Beginner 2007 or earlier No
ISERR Spots errors other than #N/A. Advanced 2007 or earlier No
ISERROR Checks for any error, including #N/A. Beginner 2007 or earlier No
ISEVEN Checks whether a whole number is even, handy for alternating rows. Intermediate 2007 or earlier No
ISFORMULA Tells you whether a cell contains a formula rather than a typed value. Intermediate 2013 No
ISLOGICAL Checks whether a value is a logical. Intermediate 2007 or earlier No
ISNA Detects the not-available error returned by failed lookups. Intermediate 2007 or earlier No
ISNONTEXT The opposite of ISTEXT. Intermediate 2007 or earlier No
ISNUMBER Checks whether something is truly numeric, a quick test for text-formatted numbers. Beginner 2007 or earlier No
ISODD Checks whether a whole number is odd. Intermediate 2007 or earlier No
ISOMITTED Used inside LAMBDA to detect whether an optional parameter was supplied. Advanced 2024 No
ISREF Tests whether something is a reference rather than a plain value. Advanced 2007 or earlier No
ISTEXT Checks whether a value is text. Beginner 2007 or earlier No
N Converts a value to a number; seen in old formulas and a trick for adding comments. Advanced 2007 or earlier No
NA Deliberately returns #N/A so charts skip a point or formulas flag missing data. Intermediate 2007 or earlier No
SHEET Returns the position number of a sheet in the workbook. Advanced 2013 No
SHEETS Counts the sheets in a workbook or in a 3-D reference. Advanced 2013 No
TYPE Returns a code for the kind of data in a value. Advanced 2007 or earlier No

Other categories