List of Excel IS Functions and Information Functions with Syntax and Arguments

This reference table lists all officially documented IS Functions and Information Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.

#	Excel Function	Description	Syntax with Arguments	Syntax only	Arguments only
1	CELL	Returns information about the formatting, location, or contents of a cell	=CELL(info_typeinfo_type [required]: A text value that specifies what type of cell information you want to return., [referencereference [optional]: The cell that you want information about.])	=CELL(info_type, [reference])	info_type (required): A text value that specifies what type of cell information you want to return. reference (optional): The cell that you want information about.
2	ERROR.TYPE	Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists	=ERROR.TYPE(error_valerror_val [required]: The error value whose identifying number you want to find.)	=ERROR.TYPE(error_val)	error_val (required): The error value whose identifying number you want to find.
3	INFO	Returns information about the current operating environment	=INFO(type_texttype_text [required]: Text that specifies what type of information you want returned.)	=INFO(type_text)	type_text (required): Text that specifies what type of information you want returned.
4	ISBLANK	Checks if value refers to empty cell	=ISBLANK(valuevalue [required]: The value that you want tested.)	=ISBLANK(value)	value (required): The value that you want tested.
5	ISERR	Checks if value is any error value ((#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!)	=ISERR(valuevalue [required]: The value that you want tested.)	=ISERR(value)	value (required): The value that you want tested.
6	ISERROR	Checks if value is any error value ((#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!)	=ISERROR(valuevalue [required]: The value that you want tested.)	=ISERROR(value)	value (required): The value that you want tested.
7	ISEVEN	Checks if value is an even number	=ISEVEN(numbernumber [required]: The value to test.)	=ISEVEN(number)	number (required): The value to test.
8	ISFORMULA	Checks if value is a formula	=ISFORMULA(referencereference [required]: Reference is a reference to the cell you want to test.)	=ISFORMULA(reference)	reference (required): Reference is a reference to the cell you want to test.
9	ISLOGICAL	Checks if value is a logical value	=ISLOGICAL(valuevalue [required]: The value that you want tested. )	=ISLOGICAL(value)	value (required): The value that you want tested.
10	ISNA	Checks if value is #N/A (value not available)	=ISNA(valuevalue [required]: The value that you want tested. )	=ISNA(value)	value (required): The value that you want tested.
11	ISNONTEXT	Checks if value is a non-text vlue	=ISNONTEXT(valuevalue [required]: The value that you want tested.)	=ISNONTEXT(value)	value (required): The value that you want tested.
12	ISNUMBER	Checks if value is a number	=ISNUMBER(valuevalue [required]: The value that you want tested.)	=ISNUMBER(value)	value (required): The value that you want tested.
13	ISODD	Checks if value is an odd number	=ISODD(valuevalue [required]: The value that you want tested.)	=ISODD(value)	value (required): The value that you want tested.
14	ISREF	Checks if value is a reference	=ISREF(valuevalue [required]: The value that you want tested.)	=ISREF(value)	value (required): The value that you want tested.
15	ISTEXT	Checks if value is a text	=ISTEXT(valuevalue [required]: The value that you want tested.)	=ISTEXT(value)	value (required): The value that you want tested.
16	N	Returns a value converted to a number	=N(valuevalue [required]: The value you want converted.)	=N(value)	value (required): The value you want converted.
17	NA	Returns the error value #N/A	=NA()	=NA()
18	SHEET	Returns the sheet number of the reference sheet	=SHEET(valuevalue [required]: Value is the name of a sheet or a reference for which you want the sheet number.)	=SHEET(value)	value (required): Value is the name of a sheet or a reference for which you want the sheet number.
19	SHEETS	Returns the number of sheets in a reference	=SHEETS(referencereference [required]: Reference is a reference for which you want to know the number of sheets it contains.)	=SHEETS(reference)	reference (required): Reference is a reference for which you want to know the number of sheets it contains.
20	TYPE	Returns the type of value	=TYPE(valuevalue [required]: Can be any Microsoft Excel value, such as a number, text, logical value, and so on.)	=TYPE(value)	value (required): Can be any Microsoft Excel value, such as a number, text, logical value, and so on.

Microsoft Excel Shortcuts

Advertising for Consideration:

Ads for Consideration: