Microsoft Office Tutorials and References
In Depth Information
Text functions enable you to manipulate text strings in formulas. For example, you can use the MID function to
extract any number of characters beginning at any character position. Other functions enable you to change the
case of text: convert to uppercase, for example.
This category consists of only seven functions that enable you to test a condition, for logical TRUE or FALSE.
You will find the IF function very useful because it gives your formulas simple decision-making capabilities.
The functions in this category help you determine the type of data stored within a cell. For example, the
ISTEXT function returns TRUE if a cell reference contains text. Or you can use the ISBLANK function to de-
termine whether a cell is empty. The CELL function returns lots of potentially useful information about a partic-
Functions that appear in this category are custom worksheet functions created by using VBA. These functions
can operate just like Excel's built-in functions. One difference, however, is that custom functions do not always
display a description of each argument in the Paste Function dialog box. It's up to the programmer to provide
The functions in this category can prove useful for engineering applications. They enable you to work with
complex numbers and to perform conversions between various numbering and measurement systems.
The functions in this category allow you to manipulate data that is part of an OLAP data cube.
The Compatibility category was new to Excel 2010. Functions in this category are statistical functions that have
been replaced with more accurate functions. However, they are still available for situations in which you need
to share your workbook with those who don't have Excel 2010.
A functional IMAGINARY tale
I've been sleeping on a COT for a MONTH NOW because I don't have any CLEAN SHEETS LEFT. So TODAY I
went looking for SHEETS — SUMPRODUCT that offers REAL VALUE for the DOLLAR. The MEDIAN cost varies
in different AREAS, so I got on the Internet AND did a SEARCH to LOOKUP SHEETS. There were many to
CHOOSE from: ROWS of every TYPE of SHEET you can think of, EVEN in the MID PRICE range. I thought it
would take DAYS, but I got lots of INFO in a MINUTE. Excellent WEBSERVICE.
It wasn't a WORKDAY, so I decided to visit a local store. I found the ADDRESS AND saw their SIGN. Shopping
isn't something I do with any FREQUENCY, but SUM times, it seems like the RIGHT thing to do.