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.