Go Back

Excel INFO Function

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

 

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