Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns information about the current operating environment .

The syntax of the function is the following:

INFO(type_text)

type_text: The type of information we need.

type_textDescription
“directory”The path of the current folder
“numfile”The number of active worksheets in the open workbooks
“origin”Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, as text prepended with “$A:”.
“osversion”The version (as text) of the current operating system.
“recalc”The recalculation mode (“Automatic” or “Manual”)
“release”The version (as text) of Excel
“system”The name of the operating Environment (Macintosh=”mac”, Windows=”pcdos”)

Here is an example of how to use the INFO function:

Use the proper function in the cell Α1 to display the current folder or directory.

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*