Using Information Functions
You can use information functions to help you determine the type of information in a cell or display information about formatting, location, or contents of a cell. The following information functions return TRUE when the function is valid: ISBLANK, ISERR, ISERROR, ISFORMULA (New!), ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, and ISTEXT. The other main information functions are CELL, INFO, TYPE, and ERROR.TYPE, which display information about the cell contents. The SHEET function (New!) returns the sheet number of the referenced sheet, while the SHEETS function (New!)returns the number of sheets in a reference.
Use Information Functions
Click the cell where you want to place the function.
Type = ...
Get Excel® 2013 On Demand 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.
