How to use INFO function in excel

Excel version in which INFO function can work:

INFO function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010.

This function is not available in Excel Web App.

About INFO function in excel:

You can get information about current environment like current directory, operating system, excel version and many more using INFO function.

Syntax for INFO Function:

=INFO (type_text)

Parameters:

Type_text [Required]: to specify what type of information you want as output.

You can use following parameters to get the information:
“DIRECTORY” Path of the current directory or folder
“NUMFILE” Number of active worksheets in open workbooks
“ORIGIN” Top-left cell visible in the current Excel spreadsheet.
“OSVERSION” Operating system version.
“RECALC” Returns the recalculation mode selected in excel- either Automatic or Manual.
“RELEASE” Version of Excel that you are running.
“SYSTEM” Name of the operating environment/ system.”

Using INFO function:

You can use INFO to get following different information in excel cell.

info function

Leave a Reply

Your email address will not be published. Required fields are marked *