INFO(type_text)
Type_text is text that specifies what type of information you want returned.
Type_text Returns
"directory" Path of the current directory or folder.
"memavail" Amount of memory available, in bytes.
"memused" Amount of memory being used for data.
"numfile" Number of active worksheets in the open workbooks.
"origin" Absolute A1-style reference, as text, prepended with "$A:" for Lotus 1-2-3 release 3.x compatibility. Returns the cell reference of the top and leftmost cell visible in the window, based on the current scrolling position.
"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"
"totmem" Total memory available, including memory already in use, in bytes.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How?
Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.
Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
1
2
A B
Formula Description (Result)
=INFO("numfile") Number of active worksheets (varies)
=INFO("recalc") Recalculation mode for the workbook (Automatic or Manual)
