INFO

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