Excel INFO function
Function INFO
Description Excel INFO function returns a text string containing information about the current operating environment.
Syntax INFO(type_text)
Type_text Required. Text that specifies what type of information have to return.
| type_text | Information Returned |
| “directory” | Path of the current directory |
| “numfile” | The number of active worksheets in all currently open Excel Workbooks |
| “origin” | Returns the top left cell reference of the current worksheet (generally A1) and the top left cell that is currently visible in the scrolled area of the current worksheet. |
| “osversion” | Current operating system version |
| “recalc” | Current recalculation mode (either “Automatic” or “Manual”) |
| “release” | Current version of Microsoft Excel |
| “system” | Current operating environment (“mac” = Macintosh or “pcdos” = Windows) |
Example:
Usage Notes:
- If the type_text argument is any other invalid value then it returns #VALUE!