INFO function - The function returns the current operating environment information in Excel

INFO function: The function returns the current operating environment information. Syntax: INFO (type_text)

The following article introduces you to the INFO function - one of the functions in the group of information functions that is very popular in Excel.

INFO function - The function returns the current operating environment information in Excel Picture 1INFO function - The function returns the current operating environment information in Excel Picture 1

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 operating system 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:

INFO function - The function returns the current operating environment information in Excel Picture 2INFO function - The function returns the current operating environment information in Excel Picture 2

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

INFO function - The function returns the current operating environment information in Excel Picture 3INFO function - The function returns the current operating environment information in Excel Picture 3

- Press Enter -> return value is:

INFO function - The function returns the current operating environment information in Excel Picture 4INFO function - The function returns the current operating environment information in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

INFO function - The function returns the current operating environment information in Excel Picture 5INFO function - The function returns the current operating environment information in Excel Picture 5

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

Good luck!

5 ★ | 1 Vote