Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd Edition

Chapter 15

Digging Up the Facts

In This Chapter

arrow Getting information about a cell or range

arrow Finding out about Excel or your computer system

arrow 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, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book