INFO Function - Retrieves information about the current operating environment in Excel

This article introduces you to the INFO function – one of the widely used information functions in Excel.

Description: Returns information about the current operating environment.

Syntax: INFO(type_text)

In this context:

- type_text: Determines the type of information to return, a mandatory parameter. It includes the following information:

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

+ type_text = “NUMFILE” -> the function returns the number of sheets in the current workbook.

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

+ type_text = “OSVERSION” -> the function returns the current operating system version in text format.

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

+ type_text = “RELEASE” -> the function returns the version of Microsoft Excel in text format.

+ type_text = “SYSTEM” -> the function returns the name of the current operating system environment.

Example:

Identify information about the operating system environment as described in the data table below:

- In the cell where you want to calculate, enter the formula: =INFO(C6)

- Press Enter -> the returned value is:

- Similarly, copy the formula for the remaining values to get the result:

Here is the guide and some specific examples of using the INFO function in Excel.

Wishing you success!