Information
★ 25 · ◉ 177 · All versions
=CELL()
Returns information about a cell, such as its address, format, file name, or column width
=CELL(info_type, [reference])
Worksheet Info & Navigation
⇄
Filter in full list
Information · Compatibility
53 functions in this category · showing 22 available
Information
★ 20 · ◉ 105 · Excel 2013
=SHEET()
Returns the sheet number according to its position in the workbook
=SHEET([value])
Worksheet Info & Navigation
Information
★ 8 · ◉ 92 · All versions
=ISNONTEXT()
Checks that a value is not text
=ISNONTEXT(value)
Error Handling
Information
★ 6 · ◉ 86 · 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
★ 10 · ◉ 71 · All versions
=N()
Converts a value to a number; text becomes zero and TRUE becomes 1
=N(value)
Error Handling
Information
★ 10 · ◉ 66 · All versions
=ISLOGICAL()
Checks whether a value is logical (TRUE or FALSE) or not?
=ISLOGICAL(value)
Error Handling
Information
★ 5 · ◉ 39 · All versions
=INFO()
Returns information about the Excel and system environment
=INFO(type_text)
Worksheet Info & Navigation
Information
★ 10 · ◉ 6 · All versions
=ERROR.TYPE()
Returns the error type of a cell as a number
=ERROR.TYPE(error_val)
Error Handling
Information
★ 20 · ◉ 5 · All versions
=ISTEXT()
Checks whether an input value is text or not?
=ISTEXT(value)
Data Cleaning
Error Handling
Information
★ 8 · ◉ 5 · All versions
=TYPE()
Returns the type of a value as a number
=TYPE(value)
Error Handling
Worksheet Info & Navigation
Information
★ 50 · ◉ 4 · All versions
=ISNUMBER()
Checks whether a value is numeric or not?
=ISNUMBER(value)
Data Cleaning
Comparation
Information
★ 60 · ◉ 3 · All versions
=ISBLANK()
Checks whether a cell is empty or not?
=ISBLANK(value)
Error Handling
Conditional Formatting & Validation
Information
★ 20 · ◉ 3 · Excel 2013
=ISFORMULA()
Checks whether a cell contains a formula or not?
=ISFORMULA(reference)
Error Handling
Conditional Formatting & Validation
Information
★ 60 · ◉ 3 · All versions
=ISNA()
Whether it is the #N/A error or not
=ISNA(value)
Comparation
Error Handling
Information
★ 30 · ◉ 3 · All versions
=ISODD()
Checks whether a number is odd or not?
=ISODD(number)
Error Handling
Conditional Formatting & Validation
Information
★ 15 · ◉ 3 · All versions
=NA()
Deliberately places the #N/A error in a cell to indicate that the value is not available
=NA()
Error Handling
Information
★ 30 · ◉ 2 · All versions
=ISEVEN()
Checks whether a number is even or not?
=ISEVEN(number)
Error Handling
Conditional Formatting & Validation
Information
★ 5 · ◉ 2 · Excel 365
=ISOMITTED()
Checks whether a LAMBDA input was left empty or not
=ISOMITTED(argument)
Error Handling
Advanced Formulas
Information
★ 20 · ◉ 2 · Excel 2013
=SHEETS()
Returns the number of sheets in the workbook or the number of sheets in a reference
=SHEETS([reference])
Worksheet Info & Navigation
Information
★ 60 · ◉ 1 · All versions
=ISERR()
Whether a formula is an error or not
=ISERR(value)
Error Handling
Information
★ 50 · ◉ 1 · All versions
=ISERROR()
Checks whether a value is an error or not?
=ISERROR(value)
Error Handling
Information
★ 15 · ◉ 1 · Excel 2013
=STOCKHISTORY()
Returns the price, volume, and stock information history from the stock market (Excel 365)
=STOCKHISTORY(stock, [start_date], [end_date], [interval], [headers], [properties])
Daily Tasks