Excel INFO Function
Summary
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.
Purpose
Get information about current environment
Return value
The information requested
Syntax
=INFO (type_text)
Arguments
- type_text - The information type to return as text.
Usage notes
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:
| Type | Information |
| directory | Path of the current directory or folder |
| numfile | Number of active worksheets in open workbooks |
| origin | First visible cell at upper left |
| osversion | Operating system version |
| recalc | Recalculation mode |
| release | Excel version |
| system | Operating system name |
Note: INFO is a volatile function and will update each time a change is made to the worksheet.
INFO formula examples
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.
How this...
Related functions
Good links
