Easy Microsoft® Office Excel 2003 > Working with Formulas and Functions > Fixing the #### Error - Pg. : Creative Edge

Table of Contents

This Book

Easy Microsoft® Office Excel 2003

Easy Microsoft® Office Excel 2003

Search

Contents

About the Author

Acknowledgments

We Want to Hear from You!

It's as Easy as 1-2-3

Pt. 1. Getting Started

Pt. 2. Managing and Viewing Workbooks

Pt. 3. Editing Worksheets

Pt. 4. Formatting Worksheet Data

Pt. 5. Working with Formulas and Functions

Functions and Correcting Errors

Using AutoSum (SUM)

Finding a Cell Average (AVERAGE)

Finding the Largest Cell Amount (MAX)

Counting the Number of Cells (COUNT)

Finding the Smallest Cell Amount (MIN)

Entering a Formula

Editing a Formula or Function

Copying a Formula

Assigning Names to a Cell or Range

Referencing Names in a Function

Using Functions Across Worksheets

Using AutoCalculate

Finding Functions

Calculating a Loan Payment (PMT)

Performing a Logical Test Function (IF)

Adding a Range Given Criteria (SUMIF)

Finding the Future Value of an Investment (FV)

Fixing the #### Error

Fixing the #DIV/0! Error

Fixing the #NAME? Error

Fixing the #VALUE! Error

Recognizing the #REF! Error

Recognizing Circular References

Checking for Formula References (Precedents)

Checking for Cell References (Dependents)

Pt. 6. Working with Charts

Pt. 7. Working with Graphic Objects

Pt. 8. Working with Data Lists

Pt. 9. Printing in Excel

Pt. 10. Advanced Excel and Web Features

URL

Help

Fixing the #### Error

If one of the cells in your worksheet contains the #### error, click on the cell's column border and drag it to increase the column width.

Drop the column border and the error disappears, and the cell's actual data is displayed.

PREVIEW

Not a subscriber?

Start A Free Trial