Home / Formula Types / Info

What is an INFO formula in a spreadsheet?

Info formulas and functions provide information about data. They can retrieve details about data types, formatting, cell references, and other properties. These formulas are useful for obtaining specific information or metadata about cells or ranges within a spreadsheet.

INFO formula usage examples.

The CELL function returns information about a specified cell in a worksheet. It can be used to retrieve various types of information, such as the address, filename, or content type of a cell. The info_type argument specifies the type of information to be returned, and the reference argument specifies the cell to be analyzed.

ERROR.TYPE

The ERROR.TYPE function in Excel returns a number corresponding to the error value in a different cell. It can be used to identify the type of error in a cell and perform specific actions based on the error type.

The ISBLANK function is used to check whether a specified cell is empty or not. It returns TRUE if the cell is empty, and FALSE if it contains any value or formula.

The ISDATE function is used to check whether a given value is a date. It returns TRUE if the value is a date, and FALSE otherwise. This function is useful for validating date inputs or filtering data based on date values.

The ISEMAIL function checks whether a value is a valid email address. It returns TRUE if the value is a valid email address, and FALSE otherwise.

The ISERR function is used to check whether a value is an error other than `#N/A`. It returns TRUE if the value is any error other than `#N/A`, and FALSE otherwise.

The ISERROR function is used to check whether a value is an error. It returns TRUE if the value is an error, and FALSE otherwise. This function is particularly useful for error handling, conditional formatting, and data validation in Microsoft Excel.

ISFORMULA

The ISFORMULA function is used to check whether a cell contains a formula. It returns TRUE if the cell contains a formula, and FALSE if it does not. This function is particularly useful when we want to perform different actions based on whether a cell contains a formula or not.

ISLOGICAL

The ISLOGICAL function is used to check whether a value is a logical value (TRUE or FALSE). It returns TRUE if the value is a logical value, and FALSE otherwise.

The ISNA function is used to check whether a value is the error #N/A. It returns TRUE if the value is #N/A, and FALSE otherwise.

ISNONTEXT

The ISNONTEXT function is used to check whether a value is non-textual. It returns TRUE if the value is not text, and FALSE if it is text. This function is useful when you need to perform different operations based on the type of data in a cell.

ISNUMBER

The ISNUMBER function is used to check whether a value is a number. It returns TRUE if the value is a number, and FALSE otherwise.

The ISREF function is used to check whether a value is a valid cell reference. It returns TRUE if the value is a valid cell reference, and FALSE otherwise. This function is commonly used in conditional formatting rules, data validation, and other scenarios where it is necessary to validate cell references.

The ISTEXT function is used to check whether a value is text. It returns TRUE if the value is text, and FALSE if it is not.

The N function is used to convert a value into a number. If the value is already a number, it is returned as is. If the value is a text representation of a number, it is converted into a number. If the value is any other type, such as a date or a logical value, it returns an error.

The TYPE function is used to determine the type of data passed into the function. It returns a number that represents the type of data. The possible return values are: 1 for numbers, 2 for text, 4 for logical values, 8 for error values, and 16 for arrays.

We use cookies on our site.