INFO Function

Returns information about the current operating environment.

Category

Information

Available in

All versions, Microsoft 365

Returns

Text or a number about the Excel environment

Want to practice INFO in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

INFO reports facts about Excel itself rather than about a cell: the version number, the operating system, how many worksheets are open, or whether calculation is automatic.

It's mostly used in shared templates — for example, warning people when calculation has been switched to manual.

Syntax

=INFO(type_text) Explain

Arguments

ArgumentRequired?What it does
type_textYesWhat you want to know, in quotes: "directory", "numfile", "origin", "osversion", "recalc", "release" or "system".

Examples

Example 1 — What each type_text returns

Typical results in Excel for Windows. Your answers depend on your computer and version.

AB
1type_textExample result
2directoryC:\Users\Amara\Documents\
3numfile3 (worksheets in all open workbooks)
4origin$A:$A$1 (top-left visible cell)
5osversionWindows (64-bit) NT 10.00
6recalcAutomatic
7release16.0
8systempcdos (Windows) or mac
Typical results — INFO describes the computer it runs on.

Example 2 — Warn when calculation is manual

Put this near the top of a model so nobody trusts stale numbers.

=IF(INFO("recalc")="Manual","⚠ Calculation is set to Manual — press F9","") Explain

Common mistakes

  • Not every type works everywhere. Excel for the web and some Mac versions return #N/A or #VALUE! for some types, such as "directory".

Notes

  • In our practice Sandbox, "directory" returns #N/A because the practice spreadsheet isn't saved in a folder.
  • Related functions: CELL, SHEETS.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.