Practice free

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

Practice this in the app

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.

FormulaExcel showsCase
=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 .