Excel Information Functions and Formulas

6137494695 
Tips and Ideas on Excel 
Tips and Ideas on Macros 
Excel Chapter 17 of 24: Excel Information Functions and FormulasExcel offers you 17 functions in the information category. Here are the ones (4) that you will use more often. 
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. 
Next Chapter: Logical Functions and Formulas in Excel 
Excel Table of Contents 
Discover Even More in 50 Excel spreadsheets 

6137494695 
Tips and Ideas on Excel 
Tips and Ideas on Macros 
Excel Information Functions and Formulas