INFO Function In Excel With Example

INFO ()

This function provides information about the operating environment of the computer.

Best view in desktop mode.

	A	B	C	D
1	Text	Window Environment
2	directory	C:\Users\300554\Documents\	=INFO("DIRECTORY")
3	numfile	196	=INFO("NUMFILE")
4	origin	$A:$A$1	=INFO("ORIGIN")
5	osversion	Windows (32-bit) NT 6.02	=INFO("OSVERSION")
6	recalc	Automatic	=INFO("RECALC")
7	release	15.0	=INFO("RELEASE")
8	system	pcdos	=INFO("SYSTEM")
9

 

 

 

Syntax

=INFO (Text)

 

Where Text is the item you required information about.

 

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

 

 

Formatting

No special formatting is needed.

 

 

 

  

ISTEXT in Excel

<<  Previous

Next  >>

DCOUNT in Excel