Get Email Subscription

Enter your email address:

Delivered by FeedBurner

Wednesday, May 12, 2010

INFO Function (Functions in Excel)



System Information
Current directory
C:\Documents and Settings\Ismail Naushad Ali\My Documents\
 =INFO("directory")
Available bytes of memory
#N/A
 =INFO("memavail")
Memory in use
#N/A
 =INFO("memused")
Total bytes of memory
#N/A
 =INFO("totmem")
Number of active worksheets
                                 179
 =INFO("numfile")
Cell currently in the top left of the window
$A:$A$1
 =INFO("origin")
Operating system
Windows (32-bit) NT 5.01
 =INFO("osversion")
Recalculation mode
Automatic
 =INFO("recalc")
Excel version
12.0
 =INFO("release")
Name of system. (PC or Mac)
pcdos
 =INFO("system")

What Does It Do?
This function provides information about the operating environment of the computer.
Syntax
 =INFO(text)
   text : This is the name of the item you require information about.
Formatting
The results will be shown as text or a number depending upon what was requested.


Related Posts by Categories



0 comments:

About This Blog

Lorem Ipsum

  © Blogger templates Newspaper III by Ourblogtemplates.com 2008

Back to TOP