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
| Row | A |
|---|---|
| 6 | Input |
| 7 | system |
| 8 | release |
| 9 | recalc |
Record 1
=INFO(A7)Illustrative outputOperating environment
See the inputs and instructions for all 3 examplesWorked 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 |