Security Use this feature with caution. Sensitive or confidential information could be revealed to other users.
Returns information about the current operating environment.
Syntax
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" | 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"
for more information on reference styles, see About cell and range references. |
| "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. |
ExampleThe example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note 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.
|
|
| A |
B |
| Formula |
Description (Result) |
| =INFO("numfile") |
Number of active worksheets (varies) |
| =INFO("recalc") |
Recalculation mode for the workbook (Automatic or Manual) |
|
United States
Email this link
Printer-Friendly Version
Share
Hide All
