Purpose
Get information about current environment
Return value
The information requested
Syntax
=INFO(type_text)- type_text - The information type to return as text.
Using the INFO function
The INFO function can retrieve information about the current environment, including the operating system, the operating system version, Excel version, and so on. INFO takes one argument, type_text, which is a text value indicating the type of information to be returned.
Examples
To use the INFO function, supply the type of information you want as text. For example, to retrieve the operating system, use "system":
=INFO("system") // returns "pcdos" or "mac"
To request Excel release information, use "release":
=INFO("release") // returns string like "16.0"
There are seven types of information you can request, summarized in the table below:
| Type | Information |
|---|---|
| directory | Path of the current directory or folder |
| numfile | Number of active worksheets in open workbooks |
| origin | First visible cell at upper left |
| osversion | Operating system version |
| recalc | Recalculation mode |
| release | Excel version |
| system | Operating system name |
Note: INFO is a volatile function and will update each time a change is made to the worksheet. This can cause performance problems in larger or more complicated workbooks.
