|
Excel Index and Search Tool (Click
on the buttons below) |
Excel Lesson 24 of 30: Microsoft Excel Information Functions |
Functions | What it Does |
CELL | Returns information about the formatting, location, or contents of a cell |
ISERROR | Returns TRUE if the value is any error value |
ISNUMBER | Returns TRUE if the value is a number |
ISTEXT | Returns TRUE if the value is text |
Examples of Basic Information Formulas CELL, MID, FIND
If you want the name and path of the
active spreadsheet to be entered automatically in
a cell, use the formula: =CELL("filename") ISERROR/ISNA
When a formula refers to a cell in
which you have another formula, always use the
ISERROR function to avoid trashing the last
formula with a "#DIV/0" or a "#VALUE" or a
"#N/A". In UK all
postal codes start by a prefix of one or two letters. My correspondent
wanted a formula to extract the prefixes so he could make a list
of them. With the postal codes in column one the following formula
in column 2 would do the job. |
Excel Index and Search Tool (Click
on the buttons below) |
|