Go Back

Excel INFO Function

Excel INFO function returns information regarding the existing environment: spreadsheet number, workbook number, and platform. However, there are several requirements that need to be provided as below:

Syntax

=INFO(type_text)

Explanation

The INFO function easily recovers 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

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

want to display info on one sheet "IF" info is correct on another sheet.
Solved by K. B. in 13 mins
I need to add =SUMIF(Info!C4:D4,"=8","/2") into an existing formula. =SUM(Info!D4-Info!C4,(SUMIF(Info!C4:D4,"=1")/2*8)). when I try to add it in it brings up errors
Solved by K. U. in 25 mins
Verify info from tab 1 and 2 - then input info from other colums into another tab
Solved by X. W. in 18 mins

Leave a Comment

avatar