The info function for Excel

The info function, which has a special purpose in Excel, gives you an introduction to the usage and examples of the info function.

function function: Returns information about the current operating environment.

function Syntax:

INFO (Type_text)

Parameter description: Type_text as text, indicating the type of information to return.

The specific value of the parameter:

If the Type_text parameter is the following character, the function is as follows:

The path to the current directory or folder for the directory.

The memory space available for "Memavail" in bytes.

Memory space occupied by the "memused" data.

The number of active worksheets in the workbook opened by "Numfile".

An absolute reference to the "origin" a1-style, in textual form, prefixed with the prefix "$A:" Compatible with the Lotus 1-2-3 version 3.x. Returns the cell in the upper-right corner of the window that is visible, based on the current scrolling position.

"OSVersion" The version number of the current operating system, the text value.

The current recalculation of "Recalc", which returns either "Automatic" or "manual".

"Release" Microsoft Excel version number, text value.

"System" Operating system name: Macintosh = "Mac" Windows = "PCDOs"

"Totmem" all memory space, including the memory space already occupied, in bytes.

Practical application

=info ("Numfile") returns 3, which means the number of worksheets. This is the default.

=info ("Recalc") returns the version number of 11, or 2003.

=info ("OSVersion") returns the Windows (32-bit) NT 5.02, which is the operating system version number of Win2003.