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!
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: