Returns information about the current operating environment.
Syntax
INFO(type_text)
Type_text is text specifying 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. |
|
"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. |
Examples
The following formula returns 2 if two worksheets are currently open:
INFO("numfile")