INFO Function(WS)

Description

The Microsoft Excel INFO function returns information about the operating environment.

Syntax

The syntax for the INFO function in Microsoft Excel is:

INFO( type )

Parameters or Arguments

type

The type of information that you wish to retrieve about the operating environment.type can be one of the following values:

Value	Explanation
directory	Path of the current directory.
numfile	Number of active worksheets.
origin	The cell that is in the top, left-most cell visible in the current Excel spreadsheet.
osversion	Operating system version.
recalc	Returns the recalculation mode - either Automatic or Manual.
release	Version of Excel that you are running.
system	Name of the operating environment.

Applies To

• Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

• Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel INFO function examples and explore how to use the INFO function as a worksheet function in Microsoft Excel:

Based on the Excel spreadsheet above, the following INFO examples would return:

=INFO("RECALC")
Result: "Automatic"

=INFO("NUMFILE")
Result: 3

=INFO("OSVERSION")
Result: "Windows (32-bit) NT 6.01"