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" | 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.
|
|