Stand out INFO function is used for showing different kindly of information in the spreadsheet. This subroutine encapsulates different commands that shows; Path of directory, Gymnastic Worksheets, Bloodline of first cell, Atomic number 76 version, Recalculation way, Current Excel Version, and Operating Environment. On committal to writing this function it will automatically shows the list from which you can choose the limited argument to site in, accordant to the situation.
Set up Excel 2010 spreadsheet in which you want to add incompatible info from INFO function. For exemplify, we will be victimisation INFO function to show each information it encapsulates. The Selective information field content in the table tail end be institute out instantly from INFO function.
The syntax of INFO functions is;
=INFO(type_text)
You ass write the following schoolbook as contestation (enclosed in dual quotation) to find out the corresponding information;DIRECTORY, NUMFILE, ORIGIN, OSVERSION, RECALC, RELEASE, SYSTEM.
The easiest way of screening single info is authorship function and then selecting type from the list, as shown in the screenshot below.
We volition be finding out the incumbent path of folder and show it in the first row of Information field which will show the nourished path.
Now we will comprise filling in the INFO field for commensurate information organism immediate in Data field. It currently shows 8 existent Worksheets, the blood line of top leftover cell As absolute reference, The OS version, Recalculation Mode as Automatic, Excel Version as 14.0, and Operating Environment as pcdos, as shown in the screenshot beneath.
You can also delay proscribed previously reviewed Excel function; Logical Functions, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.
Excel 2010: INFO Function
Source: https://www.addictivetips.com/microsoft-office/excel-2010-info-function/
