INFO

Get information about current environment

Sponsored Link

INFO

Purpose 

Get information about current environment

Return value 

The information requested

Syntax 

=INFO (type_text)

Arguments 

  • type_text - The information type to return as text.

Usage notes 

The INFO function can retrieve information about the current environment, including OS, OS version, Excel version, and so on. To use the INFO function, supply the type of information you want as text. There are seven types of information you can request:

TypeInformation
directoryPath of the current directory or folder
numfileNumber of active worksheets in open workbooks
originFirst visible cell at upper left
osversionOperating system version
recalcRecalculation mode
releaseExcel version
systemOperating system name

Note that INFO is a volatile function and will update each time a change is made to the worksheet. 

Sponsored Link

0 votes. 0 / 5