While working on a spreadsheet, excel info function provides information regarding the existing environment. For example, spreadsheet number in workbooks, platforms, and much more. You need to provide the relevant information for using INFO function.
Syntax
The formula of excel info function is given below
=INFO (type_text)
Explanation
Excel info function easily recover data of the existing environment such as OS version, OS, and Excel versions. You need to provide the kind of information that you wish to be recovering as text. You can request your desired information from the following categories:
Example
In this example, we have provided the desired information to recover data as text form as shown in the figure. The INFO formula for the B5 is
=INFO (B5)
Figure 1. Example of Excel INFO function
Leave a Comment