Excel Information Functions and Formulas
|
613-749-4695 |
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 |
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Excel Information Functions and Formulas