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!