How to use the INFO function in excel

The INFO function is an inbuilt function found in excel and serves as an information function. It is used to display details like recalculation mode, excel version, and the number of worksheets available in open workbooks. Also, it provides information about the operating environment, such as OS version and OS.

Description of the function

INFO function uses one argument:

Type _text (this is a text that provides the type of information returned)

You have to supply the type of information you want to use the INFO function.

There are seven different types of information to request. This syntax includes:

Type: information request

Directory: the path of a folder or a current directory

Origin: initial visible cell

Numfile: total number of worksheets that are open in workbooks.

Os version: the current operating system

Release: Microsoft Excel version

Recalc: automatic or manual current recalculation mode

System: name of operating system

How to use the info function

Excel users can understand how to use the function through examples. Below are some of them

Examples

1. Enter the following function to check the Operating system that you are currently using. =INFO("OSVERSION")

2. Enter the following function to determine the number of active worksheets: =INFO("NUMFILE")

3. Enter the following formula to find the path or current directory: =INFO("DIRECTORY")

4. Enter the following formula to find your current Microsoft Excel Version =INFO("RELEASE")

5. Enter the following function to check the calculation mode =INFO("RECALC")

6. Enter the following formula to find the top and leftmost visible cell

Tips to remember about info function excel

If the excel info function gives an error, it is likely to be the following reasons:

  • #Value error happens when the "type-text argument" is an invalid value
  • #N/A occurs when "memused", " memevail", and "totmem" type_text values give back memory information.

The function is applied to:

Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013, Excel for office 365, Excel 2011 for Mac, Excel 2019, and Excel 2016.

Final thoughts

It is easy to understand the info function in excel. For example, a statistics analyst gets get data from colleagues through excel files. The info excels function assists in getting information about several worksheets, excel versions, and OS.