Sponsored Link
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:
| 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 that INFO is a volatile function and will update each time a change is made to the worksheet.
