Excel info functions
Info functions in Excel, explained with live examples.
22 info functions in Excel — 1 documented in depth so far, the rest indexed below and landing every week.
Documented info functions
Syntax, examples, and the equivalent — ready now.
All Excel info functions
The full set — deep dives on the way.
- ERROR.TYPE
- Returns a number corresponding to an error type
- INFO
- Returns information about the current operating environmentThis function is not available in Excel for the web.
- ISBLANK
- Returns TRUE if the value is blank
- ISERR
- Returns TRUE if the value is any error value except #N/A
- ISERROR
- Returns TRUE if the value is any error value
- ISEVEN
- Returns TRUE if the number is even
- ISFORMULA
- Returns TRUE if there is a reference to a cell that contains a formula
- ISLOGICAL
- Returns TRUE if the value is a logical value
- ISNA
- Returns TRUE if the value is the #N/A error value
- ISNONTEXT
- Returns TRUE if the value is not text
- ISNUMBER
- Returns TRUE if the value is a number
- ISODD
- Returns TRUE if the number is odd
- ISOMITTED
- Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE
- ISREF
- Returns TRUE if the value is a reference
- ISTEXT
- Returns TRUE if the value is text
- N
- Returns a value converted to a number
- NA
- Returns the error value #N/A
- SHEET
- Returns the sheet number of the referenced sheet
- SHEETS
- Returns the number of sheets in a reference
- STOCKHISTORY
- Retrieves historical data about a financial instrument and loads it as an array
- TYPE
- Returns a number indicating the data type of a value
More Excel function categories