CELL
Returns information about the formatting, location, or contents of a cell.
InformationDesktop OnlyInformation & Auditing
Information & Auditing
Information & Auditing functions help you understand what’s inside a cell, validate data types, detect errors early, and make spreadsheets more robust.
This collection groups Excel functions that are commonly used for information & auditing workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Start with the most common functions in this collection and expand as your problems get more complex.
- Combine these functions with structured tables to keep formulas readable and resilient.
Excel functions in this collection (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