Understanding Information Functions

The information functions could be considered 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 the following sections. You’ll find these functions by clicking the More Functions button on the Formulas tab on the Ribbon and then clicking Information.

Understanding Information Functions

More Functions

Using Selected Information Functions

With information functions, you can gather information about the contents of cells, their formatting, and the computing ...

Get 2007 Microsoft® Office System 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.