Info Formula
|
|
System Information
|
|
|
Current directory
|
C:\Users\Madushana\Documents\
|
=INFO("directory")
|
|
Available bytes of memory
|
1,048,576
|
=INFO("memavail")
|
|
Memory in use
|
2,736,804
|
=INFO("memused")
|
|
Total bytes of memory
|
3,785,380
|
=INFO("totmem")
|
|
Number of active worksheets
|
156
|
=INFO("numfile")
|
|
Cell currently in the top left of
the window
|
$A:$A$1
|
=INFO("origin")
|
|
Operating system
|
Windows (32-bit) NT
6.02
|
=INFO("osversion")
|
|
Recalculation mode
|
Automatic
|
=INFO("recalc")
|
|
Excel version
|
11.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.
|
||