Microsoft Office Tutorials and References
In Depth Information
Mastering Excel’s Built-in Functions
Information Functions
Most of the functions in this group are of interest to advanced worksheet developers. The
CELL function, for example, returns information about a cell—its contents, address, and
formatting and the workbook in which it’s located. The INFO function allows you to determine
information about the environment of the system on which the current worksheet is being
viewed, including the Windows version and which version of Excel is in use—extremely
useful if you’re using features that are supported only in Excel 2010, for example.
A long list of functions in this category are logical tests that begin with IS—ISERROR and
ISBLANK, for example. Use them to add logic to a formula to suppress error messages, ill
blanks with default values, and otherwise prevent you or anyone using a worksheet you
design from running into unexpected conditions.
A particularly useful function in this group allows you to return a “Not Applicable” error
message. You can use the NA function (which takes no arguments) as an argument with an
IF function to add a neat #N/A value instead of an error message when a formula returns a
particular result.
Lookup and Reference/Database/Cube Functions
We’ve combined three categories into one section here, all of them related to
managing tables of data in Excel. We discuss the most useful of these functions in more detail in
Chapter 12, “Managing Lists and Data.”
Search JabSto ::

Custom Search