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