Information
★ 60 · ◉ 39 · All versions
=ISBLANK()
Checks whether a cell is empty or not?
=ISBLANK(value)
Error Handling
Conditional Formatting & Validation
Information
★ 60 · ◉ 30 · All versions
=ISERR()
Whether a formula is an error or not
=ISERR(value)
Error Handling
Information
★ 60 · ◉ 16 · All versions
=ISNA()
Whether it is the #N/A error or not
=ISNA(value)
Comparation
Error Handling
Information
★ 50 · ◉ 52 · All versions
=ISNUMBER()
Checks whether a value is numeric or not?
=ISNUMBER(value)
Data Cleaning
Comparation
Information
★ 50 · ◉ 37 · All versions
=ISERROR()
Checks whether a value is an error or not?
=ISERROR(value)
Error Handling
Information
★ 30 · ◉ 33 · All versions
=ISEVEN()
Returns TRUE if number is even, or FALSE if number is odd.
=ISEVEN(number)
Error Handling
Conditional Formatting & Validation
Information
★ 30 · ◉ 30 · All versions
=ISODD()
Returns TRUE if number is odd, or FALSE if number is even.
=ISODD(number)
Error Handling
Conditional Formatting & Validation
Information
★ 25 · ◉ 29 · All versions
=CELL()
The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:
=CELL(info_type, [reference])
Worksheet Info & Navigation
Information
★ 20 · ◉ 53 · All versions
=ISTEXT()
Checks whether an input value is text or not?
=ISTEXT(value)
Data Cleaning
Error Handling
Information
★ 20 · ◉ 44 · Excel 2013
=ISFORMULA()
Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.
=ISFORMULA(reference)
Error Handling
Conditional Formatting & Validation
Information
★ 20 · ◉ 28 · Excel 2013
=SHEET()
The SHEET function returns the sheet number of the specified sheet or other reference.
=SHEET(value)
Worksheet Info & Navigation
Information
★ 20 · ◉ 24 · Excel 2013
=SHEETS()
Returns the number of sheets in a reference.
=SHEETS(reference)
Worksheet Info & Navigation
Information
★ 15 · ◉ 31 · Microsoft 365
=HIDDEN()
Hidden function
Worksheet Info & Navigation
Information
★ 15 · ◉ 27 · All versions
=NA()
Returns the error value #N/A. #N/A is the error value that means "no value is available." Use NA to mark empty cells. By entering #N/A in cells where you are missing information, you can avoid the problem of unintentionally including empty cells in your calculations. (When a formula refers to a cell containing #N/A, the formula returns the #N/A error value.)
=NA( )
Error Handling
Information
★ 15 · ◉ 22 · Excel 2013
=STOCKHISTORY()
STOCKHISTORY function
=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], [property2], [property3], [property4], [property5])
Daily Tasks
Information
★ 10 · ◉ 61 · All versions
=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. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.
=ERROR.TYPE(error_val)
Error Handling
Information
★ 10 · ◉ 37 · All versions
=N()
Returns a value converted to a number.
=N(value)
Error Handling
Information
★ 10 · ◉ 23 · All versions
=ISLOGICAL()
Checks whether a value is logical (TRUE or FALSE) or not?
=ISLOGICAL(value)
Error Handling
Information
★ 8 · ◉ 38 · All versions
=TYPE()
Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell.
=TYPE(value)
Error Handling
Worksheet Info & Navigation
Information
★ 8 · ◉ 29 · All versions
=ISNONTEXT()
Checks that a value is not text
=ISNONTEXT(value)
Error Handling
Information
★ 6 · ◉ 25 · All versions
=ISREF()
Checks whether a value is a valid reference to a cell or range or not
=ISREF(value)
Error Handling
Worksheet Info & Navigation
Information
★ 5 · ◉ 40 · All versions
=INFO()
Returns information about the current operating environment.
=INFO(type_text)
Worksheet Info & Navigation
Information
★ 5 · ◉ 36 · Excel 365
=ISOMITTED()
The value you want to test, such as a LAMBDA parameter.
=ISOMITTED(argument)
Error Handling
Advanced Formulas