ExcelFlux

INFO function

information about the current operating environmentThis function is not available in Excel for the web.

Information · Guided Excel example

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Inspect the operating environment, Excel release and calculation mode. Results depend on your installation.

A worked example from the workbook

RowA
6Input
7system
8release
9recalc
Record 1
=INFO(A7)

Illustrative outputOperating environment

See the inputs and instructions for all 3 examples

Worked examples

Inspect the operating environment, Excel release and calculation mode. Results depend on your installation.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 system
8 release
9 recalc
Trial Expression Sample output
Record 1 =INFO(A7) Operating environment
Record 2 =INFO(A8) Excel release
Record 3 =INFO(A9) Calculation mode
Microsoft Excel reference