Advanced Excel Functions 简明教程

Advanced Excel - Information Functions

Information 函数提供有关 Excel 工作表中单元格的内容、格式和位置的信息。

Information functions provide information about the content, formatting and location of cells in an Excel Worksheet.

下表列出所有 Information 函数 −

The following table lists all the Information functions −

S.No.	Function and Description
1	CELLReturns information about the formatting, location, or contents of a cell
2	ERROR.TYPEReturns a number corresponding to an error type
3	INFOReturns information about the current operating environment
4	ISBLANKReturns TRUE if the value is blank
5	ISERRReturns TRUE if the value is any error value except #N/A
6	ISERRORReturns TRUE if the value is any error value
7	ISEVENReturns TRUE if the number is even
8	ISFORMULAReturns TRUE if there is a reference to a cell that contains a formula
9	ISLOGICALReturns TRUE if the value is a logical value
10	ISNAReturns TRUE if the value is the #N/A error value
11	ISNONTEXTReturns TRUE if the value is not text
12	ISNUMBERReturns TRUE if the value is a number
13	ISODDReturns TRUE if the number is odd
14	ISREFReturns TRUE if the value is a reference
15	ISTEXTReturns TRUE if the value is text
16	NReturns a value converted to a number
17	NAReturns the error value #N/A
18	SHEETReturns the sheet number of the referenced sheet
19	SHEETSReturns the number of sheets in a reference
20	TYPEReturns a number indicating the data type of a value