The info function for Excel

Source: Internet
Author: User

The info function, which has a special purpose in Excel, gives you an introduction to the usage and examples of the info function.

function function: Returns information about the current operating environment.

function Syntax:

INFO (Type_text)

Parameter description: Type_text as text, indicating the type of information to return.

The specific value of the parameter:

If the Type_text parameter is the following character, the function is as follows:

The path to the current directory or folder for the directory.

The memory space available for "Memavail" in bytes.

Memory space occupied by the "memused" data.

The number of active worksheets in the workbook opened by "Numfile".

An absolute reference to the "origin" a1-style, in textual form, prefixed with the prefix "$A:" Compatible with the Lotus 1-2-3 version 3.x. Returns the cell in the upper-right corner of the window that is visible, based on the current scrolling position.

"OSVersion" The version number of the current operating system, the text value.

The current recalculation of "Recalc", which returns either "Automatic" or "manual".

"Release" Microsoft Excel version number, text value.

"System" Operating system name: Macintosh = "Mac" Windows = "PCDOs"

"Totmem" all memory space, including the memory space already occupied, in bytes.

Practical application

=info ("Numfile") returns 3, which means the number of worksheets. This is the default.

=info ("Recalc") returns the version number of 11, or 2003.

=info ("OSVersion") returns the Windows (32-bit) NT 5.02, which is the operating system version number of Win2003.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.