INFO function
Summary
Returns information about the current operating environment This function is not available in Excel for the web.
Syntax
INFO(type_text)
The INFO function syntax has the following arguments:
• Type_text Required. Text that specifies what type of information you want returned.
"directory" | Path of the current directory or folder specified in the Excel option, At startup, open all files in (Select File > Options > Advanced > General).
"numfile" | Number of worksheets in the open workbooks.
"origin" | Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, as text prepended with "$A:". This value is intended for for Lotus 1-2-3 release 3.x compatibility. The actual value returned depends on the current reference style setting. Using D9 as an example, the return value would be: A1 reference style "$A:$D$9". R1C1 reference style "$A:R9C4"
"osversion" | Current operating system version, as text.
"recalc" | Current recalculation mode; returns "Automatic" or "Manual".
"release" | Version of Microsoft Excel, as text.
"system" | Name of the operating environment: Macintosh = "mac" Windows = "pcdos"
Important: In previous versions of Microsoft Excel, the "memavail", "memused", and "totmem" type_text values, returned memory information. These type_text values are no longer supported and now return a #N/A error value.
• Type_text Required. Text that specifies what type of information you want returned.
"directory" | Path of the current directory or folder specified in the Excel option, At startup, open all files in (Select File > Options > Advanced > General).
"numfile" | Number of worksheets in the open workbooks.
"origin" | Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, as text prepended with "$A:". This value is intended for for Lotus 1-2-3 release 3.x compatibility. The actual value returned depends on the current reference style setting. Using D9 as an example, the return value would be: A1 reference style "$A:$D$9". R1C1 reference style "$A:R9C4"
"osversion" | Current operating system version, as text.
"recalc" | Current recalculation mode; returns "Automatic" or "Manual".
"release" | Version of Microsoft Excel, as text.
"system" | Name of the operating environment: Macintosh = "mac" Windows = "pcdos"
Important: In previous versions of Microsoft Excel, the "memavail", "memused", and "totmem" type_text values, returned memory information. These type_text values are no longer supported and now return a #N/A error value.
Example
=INFO("numfile")
=INFO("recalc")
=INFO("recalc")