Information
★ 10 · ◉ 24 · 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
★ 20 · ◉ 22 · All versions
=ISTEXT()
Checks whether an input value is text or not?
=ISTEXT(value)
Data Cleaning
Error Handling
Information
★ 50 · ◉ 17 · All versions
=ISNUMBER()
Checks whether a value is numeric or not?
=ISNUMBER(value)
Data Cleaning
Comparation
Math & Trig
★ 85 · ◉ 16 · Excel 2010
=AGGREGATE()
The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
=AGGREGATE(function_num, options, ref1, [ref2], …)
Reporting
Ranking & Top N
Information
★ 60 · ◉ 16 · All versions
=ISBLANK()
Checks whether a cell is empty or not?
=ISBLANK(value)
Error Handling
Conditional Formatting & Validation
Information
★ 50 · ◉ 16 · All versions
=ISERROR()
Checks whether a value is an error or not?
=ISERROR(value)
Error Handling
Information
★ 8 · ◉ 16 · 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
★ 30 · ◉ 13 · All versions
=ISEVEN()
Returns TRUE if number is even, or FALSE if number is odd.
=ISEVEN(number)
Error Handling
Conditional Formatting & Validation
Information
★ 20 · ◉ 13 · 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
★ 30 · ◉ 13 · All versions
=ISODD()
Returns TRUE if number is odd, or FALSE if number is even.
=ISODD(number)
Error Handling
Conditional Formatting & Validation
Information
★ 10 · ◉ 12 · All versions
=N()
Returns a value converted to a number.
=N(value)
Error Handling
Logical
★ 75 · ◉ 11 · Excel 2013
=IFNA()
The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise it returns the result of the formula.
=IFNA(value, value_if_na)
Comparation
Error Handling
Text
★ 10 · ◉ 10 · All versions
=T()
Returns the text referred to by value.
=T(value)
Text Manipulation
Error Handling
Logical
★ 50 · ◉ 9 · Excel 2007
=IFERROR()
How to use the IFERROR function in Excel to trap and handle errors in a formula.
=IFERROR(value, value_if_error)
Daily Tasks
Error Handling
Information
★ 10 · ◉ 8 · All versions
=ISLOGICAL()
Checks whether a value is logical (TRUE or FALSE) or not?
=ISLOGICAL(value)
Error Handling
Information
★ 15 · ◉ 8 · 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
★ 60 · ◉ 7 · All versions
=ISERR()
Whether a formula is an error or not
=ISERR(value)
Error Handling
Information
★ 8 · ◉ 7 · All versions
=ISNONTEXT()
Checks that a value is not text
=ISNONTEXT(value)
Error Handling
Information
★ 60 · ◉ 6 · All versions
=ISNA()
Whether it is the #N/A error or not
=ISNA(value)
Comparation
Error Handling
Information
★ 5 · ◉ 6 · Excel 365
=ISOMITTED()
The value you want to test, such as a LAMBDA parameter.
=ISOMITTED(argument)
Error Handling
Advanced Formulas
Information
★ 6 · ◉ 5 · 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