How to use Excel INFO Function

how to use excel info function

Quick Intro

Use Excel INFO Function to get infirmation about your current operating environment. In simple words, you can get information about your application.

Syntax

INFO(type_text)

  • type_text Information which you need as a result.

More Information on Excel INFO Function

  • You have 7 different parameters to get info about your current operating environment.
directory Path of the current directory or folder
numfile Number of active worksheets in open workbooks
origin First visible cell at the upper left
osversion Operating system version
recalc Recalculation mode
release Excel version
system Operating system name

Examples

In the below example, I have used all the parameters to get info about the current operating environment.

Examples For Excel INFO Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel INFO Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have CELL function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.