Excel Info Function

This post will guide you how to use Excel INFO function with syntax and examples in Microsoft excel.

Table of Contents

Description

The Excel INFO function returns information about the operating environment.

The INFO function is a build-in function in Microsoft Excel and it is categorized as an Information Function.

The INFO function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the INFO function is as below:

= INFO (type_text)

Where the INFO function arguments are:
Type_text -This is a required argument. The type of information that you want to return about the operating environment.

The following type values can be used:

Type_text Returns
“directory” Path of the current directory or folder.
“numfile” Number of active worksheets in the open workbooks.
“origin” Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, as text prepended with “$A:”. This value is intended for for Lotus 1-2-3 release 3.x compatibility. The actual value returned depends on the current reference style setting. Using D9 as an example, the return value would be:

·         A1 reference style     “$A:$D$9”.

·         R1C1 reference style    “$A:R9C4”

“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”

From Microsoft website

Example

The below examples will show you how to use Excel INFO Function to return the information about the operating environment.

#1 =INFO(“OSVERSION”)

excel info function example1

Note: the above excel formula will return the current operating system version.

#2 =INFO(“system”)

excel info function example2

Note: The above excel formula will return the name of the current operating environment.

 

Leave a Reply