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]) |
|
| 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) |
|
| 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) |
|
| 4 | ISBLANK | Checks if value refers to empty cell | =ISBLANK(valuevalue [required]: The value that you want tested.) | =ISBLANK(value) |
|
| 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) |
|
| 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) |
|
| 7 | ISEVEN | Checks if value is an even number | =ISEVEN(numbernumber [required]: The value to test.) | =ISEVEN(number) |
|
| 8 | ISFORMULA | Checks if value is a formula | =ISFORMULA(referencereference [required]: Reference is a reference to the cell you want to test.) | =ISFORMULA(reference) |
|
| 9 | ISLOGICAL | Checks if value is a logical value | =ISLOGICAL(valuevalue [required]: The value that you want tested. ) | =ISLOGICAL(value) |
|
| 10 | ISNA | Checks if value is #N/A (value not available) | =ISNA(valuevalue [required]: The value that you want tested. ) | =ISNA(value) |
|
| 11 | ISNONTEXT | Checks if value is a non-text vlue | =ISNONTEXT(valuevalue [required]: The value that you want tested.) | =ISNONTEXT(value) |
|
| 12 | ISNUMBER | Checks if value is a number | =ISNUMBER(valuevalue [required]: The value that you want tested.) | =ISNUMBER(value) |
|
| 13 | ISODD | Checks if value is an odd number | =ISODD(valuevalue [required]: The value that you want tested.) | =ISODD(value) |
|
| 14 | ISREF | Checks if value is a reference | =ISREF(valuevalue [required]: The value that you want tested.) | =ISREF(value) |
|
| 15 | ISTEXT | Checks if value is a text | =ISTEXT(valuevalue [required]: The value that you want tested.) | =ISTEXT(value) |
|
| 16 | N | Returns a value converted to a number | =N(valuevalue [required]: The value you want converted.) | =N(value) |
|
| 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) |
|
| 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) |
|
| 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) |
|
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy