- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Information - INFO Function
Description
The INFO function returns information about the current operating environment.
Syntax
INFO (type_text)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Type_text | Text that specifies the type of Information that is to be returned. The values for Type_text and the corresponding return Information is given in the table below. |
Required |
| Type_text | Information Returned |
|---|---|
| "directory" | Path of the current directory or folder. |
| "numfile" | Number of active worksheets in the open Workbooks. |
| "origin" | Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, as text prepended with "$A:". This value is intended for Lotus 1-2-3 release 3.x compatibility. The actual value returned depends on the current Reference Style setting. For example, with D9, the return value will be − With A1 Reference Style: "$A:$D$9". With R1C1 Reference Style: "$A:R9C4". |
| "osversion" | Current operating system version, as text. |
| "recalc" | Current recalculation mode; returns "Automatic" or "Manual". |
| "release" | Version of Microsoft Excel, as text. |
| "system" | Name of the operating environment: E.g. Windows = "pcdos" |
Notes
If the type_text value is "memavail", "memused", or "totmem", INFO returns a #N/A error value.
These type_text values returned memory information in earlier versions of Excel and are no longer supported.
If the type_text value is any other invalid value, INFO returns a #VALUE! Error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
