INFO function
The INFO function in Excel provides information about the current operating environment or system configuration. It is used to retrieve details such as the Excel version, system memory, or the type of operating system.
Syntax:
INFO(type_text)
Arguments:
- type_text: A text value that specifies the type of information to return.
Common Values for type_text:
| type_text | Description | Example Result |
|---|---|---|
"directory" | Current directory or folder path. | C:\Users\Documents\ |
"numfile" | Number of active worksheets in all open workbooks. | 3 (if three sheets are open) |
"origin" | The absolute cell reference of the top-left visible cell. | $A$1 |
"osversion" | The operating system version. | Windows (10.0) |
"recalc" | The current recalculation mode. | Automatic or Manual |
"release" | The Excel version (release number). | 16.0 |
"system" | The operating system in use. | pcdos (for Windows) |
Example:
Formula:
=INFO("osversion")
Result:
Windows (10.0) (on a Windows 10 system).
Notes:
- Dynamic Results: The function reflects the current state of the system or Excel environment.
- Compatibility: Some results (like
"system"or"release") may vary depending on the Excel version or operating system. - Case-Insensitive: The
type_textargument is not case-sensitive, so"osversion"and"OSVERSION"are equivalent.
Usage:
- Debugging: Retrieve system or Excel details to ensure compatibility with macros or formulas.
- Dynamic References: Use
"directory"to dynamically set file paths in a workbook. - Environment Awareness: Determine recalculation settings or Excel version for advanced automation tasks.