The Excel INFO function returns information about the current environment, including platform, Excel version, number of worksheets in a workbook, and so on. To use the INFO function, supply the type of information you want as text. There are seven types of information available, summarized in the table below.
Get information about current environment
The information requested
type_text - The information type to return as text.
The INFO function can retrieve information about the current environment, including OS, OS version, Excel version, and so on. To use the INFO function, supply the type of information you want as text. There are seven types of information you can request:
Path of the current directory or folder
Number of active worksheets in open workbooks
First visible cell at upper left
Operating system version
Operating system name
Note: INFO is a volatile function and will update each time a change is made to the worksheet.
To add a line break taking into account the current OS (Mac or Windows), you can use the INFO function to test the system and then return the correct break character — CHAR(10) for Windows, CHAR(13) for Mac.
The Excel CELL function returns information about a cell in a worksheet. The type of information to be returned is specified as info_type. CELL can get things like address and filename, as well as detailed info about the formatting used in the...
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.