INFO function

CALC FUNCTIONS

Spreadsheet Functions

< Previous Section

Next Section >

FUNCTIONS

Spreadsheet Lookup functions

• ADDRESS
• CHOOSE
• HLOOKUP
• INDEX
• INDIRECT
• LOOKUP
• MATH
• OFFSET
• VLOOKUP

Spreadsheet Information functions

• AREAS
• COLUMN
• COLUMNS
• ERRORTYPE
• INFO
• ROW
• ROWS
• SHEET
• SHEETS

Other functions

• DDE
• HYPERLINK
• STYLE

< Previous Page

Next Page >

INFO

Returns information about the current working environment.

Syntax:

INFO(type)

type is a text string which determines the type of information to return:

type	information returned
"osversion"	Always "Windows (32-bit) NT 5.01", for compatibility reasons.
"system"	The type of the operating system: "WNT" for Microsoft Windows "LINUX" for Linux "SOLARIS" for Solaris.
"release"	The product release identifier, for example "680m9(Build:9238)".
"numfile"	Always 1, for compatibility reasons.
"recalc"	The current formula recalculation mode, either "Automatic" or "Manual", or the equivalent in your language (Tools → Options → Language Settings → Language).

Example:

INFO("system")

returns WNT on a Windows system, or other text on other operating systems as above.

---

See Also

• Information functions
• Spreadsheet functions

• Functions listed alphabetically
• Functions listed by category