The information functions could be called the internal monitoring system in Excel. Although they perform no specific calculations, you can use them to find out about elements of the Excel interface and then use that information elsewhere. We'll discuss the most useful of these functions in this section.
For more information about individual functions, see Appendix D.
Information functions allow you to gather information about the contents of cells, their formatting, and the computing environment as well as perform conditional tests for the presence of specific types of values.
The TYPE function determines whether a cell contains ...