How to Use the INFO Function in Excel

This guide explains how to use INFO Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the current operating environment information.

Syntax: INFO (type_text)

Inside:

- type_text: The value specifies the type of information to return, is a required parameter. Including the information:

+ type_text = 'DIRECTORY' -> function returns the path of the current directory.

+ type_text = 'NUMFILE' -> function returns the current number of sheets.

+ type_text = 'ORIGIN' -> function returns the absolute reference of the top and leftmost cell.

+ type_text = 'OSVERSION' -> function returns the current Supported operating systems version as a text.

+ type_text = 'RECALC' -> function returns the current calculation method.

+ type_text = 'RELEASE' -> function returns the version of Microsoft Excel as a text.

+ type_text = 'SYSTEM' -> function returns the name of the current operating environment.

For example:

Identify information about the operating environment described in the following data table:

- In the cell to calculate enter the formula : = INFO (C6)

- Press Enter -> return value is:

- Similarly copying the formula for the remaining values results:

Above are instructions and some specific examples when using the INFO function in Excel.

Good luck!