INFO function
INFO returns text or a number describing the Excel operating environment, such as the calculation mode. Its output differs by platform, and several older options were removed in current versions.
Example
A
B
C
D
1
Manual
2
3
Syntax
INFO(type_text)
-
type_text(required) - Text naming what to report, e.g. "recalc", "system", "osversion".
Returns: Text or number describing the Excel environment.
INFO is volatile: Excel works it out again every time anything in the workbook changes.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=INFO("system") | pcdos | Operating system |
=INFO("release") | 16.0 | Excel version |
=INFO("osversion") | Windows (64-bit) NT 10.00 | OS version |
=INFO("recalc") | Manual | Calculation mode (harness uses manual + full recalc) |
=INFO("numfile") | 6 | Active sheets count |
=INFO("origin") | $A:$A$1 | Top-left visible cell |
=INFO("memavail") | #N/A | Removed info type |
=INFO("bogus") | #VALUE! | Bad type |
Watch out for
- Several older type_text options were removed in current versions.
- Output differs by platform.
Where it works
- Excel
- INFO is in every version of Excel from 2007 on.
- Google Sheets
- No direct equivalent. No counterpart.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .