February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 = ...