Understanding Information Functions
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.
Cross Reference
For more information about individual functions, see Appendix D.
Using Selected Information Functions
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 and ERROR.TYPE Functions
The TYPE function determines whether a cell contains ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
