INFO

The INFO function in Excel is used to retrieve information about the current operating environment or settings within Excel. It provides details such as file names, paths, versions, and more, which can be helpful for users seeking to understand their Excel environment better.

Syntax

=INFO(type_text)

type_text A text string specifying the type of information to retrieve.
[not_available_text] Optional. A text string to display if the requested information is not available.
[directory] Optional. The directory where the file is stored.

About INFO

When you find yourself in need of essential information about your Excel environment, consider turning to the INFO function. This function serves as a valuable resource for gaining insights into various aspects of Excel settings, system paths, and configurations, enabling users to navigate their Excel workspace more effectively. By simply providing a specific 'type_text' argument, users can extract pertinent details regarding their Excel setup effortlessly. The INFO function offers a diverse range of information that can aid users in optimizing their Excel usage and enhancing their overall experience within the program.

Examples

To retrieve the Excel version, you can use the following formula: =INFO("release")

To obtain the current operating system version, you can utilize: =INFO("osversion")

If you wish to display the directory of the current workbook, you can employ: =INFO("directory", "Not Available")

Questions

What types of information can be retrieved using the INFO function?

The INFO function allows users to retrieve various details such as the Excel version, operating system version, directory paths, and more. Users can specify the type of information they wish to retrieve by providing the appropriate 'type_text' argument.

Can you provide an example of a scenario where the INFO function can be helpful?

Certainly! If a user needs to check the Excel version they are using for compatibility reasons, they can simply use the INFO function with the 'release' argument to retrieve the version information instantly.

Is the INFO function limited to only retrieving information about Excel versions?

No, the INFO function can also provide information on various aspects of the Excel environment such as file paths, directories, and system configurations. It offers a comprehensive range of insights to assist users in better understanding their Excel workspace.

Related functions

CELL ERROR.TYPE ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA SHEET SHEETS TYPE VERSION