CELL
Returns information about the formatting, location, or contents of a cell.
InformationDesktop OnlyInformation & Auditing
Information
Information functions help you check data types, errors, and conditions in Excel.
They are useful for auditing and validation.
Commonly combined with logical formulas.
Tips
- Use IS-functions to validate inputs.
- Return friendly messages instead of raw errors.
Excel functions in this category (22)
ERROR.TYPE
Returns a number corresponding to an error type.
InformationError Handling & ChecksInformation & Auditing
INFO
Returns information about the current operating environment.
InformationDesktop OnlyInformation & Auditing
ISBLANK
Returns TRUE if the value is blank.
InformationError Handling & ChecksInformation & Auditing
ISERR
Returns TRUE if the value is any error value except #N/A.
InformationError Handling & ChecksInformation & Auditing
ISERROR
Returns TRUE if the value is any error value.
InformationError Handling & ChecksInformation & Auditing
ISEVEN
Returns TRUE if the number is even.
InformationInformation & Auditing
ISFORMULA
Returns TRUE if there is a reference to a cell that contains a formula.
InformationInformation & Auditing
ISLOGICAL
Returns TRUE if the value is a logical value.
InformationInformation & Auditing
ISNA
Returns TRUE if the value is the #N/A error value.
InformationError Handling & ChecksInformation & Auditing
ISNONTEXT
Returns TRUE if the value is not text.
InformationInformation & Auditing
ISNUMBER
Returns TRUE if the value is a number.
InformationError Handling & ChecksInformation & Auditing
ISODD
Returns TRUE if the number is odd.
InformationInformation & Auditing
ISOMITTED
Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE.
InformationInformation & AuditingModern Excel Functions
ISREF
Returns TRUE if the value is a reference.
InformationInformation & Auditing
ISTEXT
Returns TRUE if the value is text.
InformationError Handling & ChecksInformation & Auditing
N
Returns a value converted to a number.
InformationInformation & Auditing
NA
Returns the error value #N/A.
InformationError Handling & ChecksInformation & Auditing
SHEET
Returns the sheet number of the referenced sheet.
InformationInformation & Auditing
SHEETS
Returns the number of sheets in a reference.
InformationInformation & Auditing
STOCKHISTORY
Retrieves historical data about a financial instrument and loads it as an array.
InformationInformation & Auditing
TYPE
Returns a number indicating the data type of a value.
InformationInformation & Auditing