Table of Contents
Entire Site
Entire Site
Titles Only
Short Cuts
Rough Cuts
Advanced Search
Help
Help
Support Home
Alerts
Top Knowledge Items
Frequently Asked Questions
Account Management
Billing
Content
Content Reader
Mobile
Offline Reading
Sign In
Reactivate
Sign Up
This Book
Easy Microsoft® Office Excel 2003
Search
search in
This Book
This Chapter
search for
Contents
Table of Contents
Index
Copyright
About the Author
Acknowledgments
We Want to Hear from You!
It's as Easy as 1-2-3
Introduction
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
Glossary
Index
Create Bookmark
Create Bookmark
Create Note or Tag
Create Note or Tag
Print
Print
Html View (Key: h)
Thumbnail View (Key: v)
Zoom Out (Key: -)
Zoom Out
Zoom In (Key: +)
Zoom In
Toggle to Full Screen (Key: f)
Previous (Key: p)
Previous
Next (Key: n)
Next
Part 5. Working with Formulas and Functions
>
Fixing the #### Error
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
Create Bookmark
Create Bookmark
Create Note or Tag
Create Note or Tag
Print
Print
Html View (Key: h)
Thumbnail View (Key: v)
Zoom Out (Key: -)
Zoom Out
Zoom In (Key: +)
Zoom In
Toggle to Full Screen (Key: f)
Previous (Key: p)
Previous
Next (Key: n)
Next