INFO function returns information about the current environment, including platform, Excel version, number of worksheets in a workbook, and so on. To use this function, supply the type of information you want as text. There are seven types of information available, summarized in the table below.
Purpose of Excel INFO Function
Get information about current environment .
The information requested.
|type_text||The information type to return as text.||Mandatory|
- This function is a volatile function and will update each time a change is made to the worksheet.
Since 2007 for Windows.
Since 2011 for Mac.