Using the Excel INFO Function
Summary
The Excel INFO function returns information about the current operating environment.Syntax
=INFO (type_text)Syntax Breakdown
Type TextRequired. Text specifying what information you are looking for. The options are as follows:
| Type_text | Output |
|---|---|
| "directory" | Current director or folder's path |
| "numfile" | Number of active worksheets in the open workbook |
| "origin" | Returns the absolute cell reference of the top leftmost cell visible in the window as text prepended with "$A:". The actual value returned will depend on the reference style setting. If cell B2 is our example, the output using A1 reference style would be: "$A:$B:$2". |
| "osversion" | Current operating version returned as text |
| "recalc" | Returns "Automatic" or "Manual" to describe the current recalculation mode |
| "release" | Version of Excel, returned as text |
| "system" | Name of the operating environment. Windows is shown as "pcdos" and Macintosh is represented as "mac" |
Usage Notes
The INFO function provides information about the current operating environment. Simply supply the function with the information, specified in the above table, you want returned.INFO is considered a volatile function, meaning it will update each time the worksheet is changed.