Understanding Information Functions

image with no caption

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 discuss the most useful of these functions in the following sections. You can find these functions by clicking the More Functions button on the Formulas tab on the ribbon and then clicking Information.

Using Selected Information Functions

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

Get Microsoft® Excel® 2010 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.