Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Digging Up the Facts
Digging Up the Facts
In This Chapter
▶ Getting information about a cell or range
▶ Finding out about Excel or your computer system
▶ Testing for numbers, text, and errors
In this chapter, I show you how to use Excel’s information functions, which
you use to obtain information about cells, ranges, and the workbook
you’re working in. You can even get information about the computer you’re
using. What will they think of next?
The information functions are great for getting formulas to focus on just the
data that matter. Some functions even help shield you from Excel’s confusing
error messages. The first time I saw the #NAME? error I thought Excel was
asking me to enter a name (just another of the more exciting Excel moments).
Now, at least I know to use the ISERROR or ERROR.TYPE functions to make
error messages more meaningful. And after reading this chapter, so will you!
Getting Informed with the CELL Function
The CELL function provides feedback about cells and ranges in a worksheet.
You can find out what row and column a cell is in, what type of formatting it
has, whether it’s protected, and so on.
CELL takes two arguments:
✓ The first argument, which is enclosed in double quotes, tells the
function what kind of information to return.
✓ The second argument tells the function which cell or range to
evaluate. If you specify a range that contains more than one cell, the function
returns information about the top-left cell in the range. The second
argument is optional; when it isn’t provided, Excel reports back on the most
recently changed cell.