Scribd
Upload
47 views1 page

Excel 45

Chapter 3 discusses how to perform calculations on data in Excel and the importance of identifying and correcting errors in formulas. It explains the auditing process for finding errors, including the use of error codes and the Error button for assistance. Common error codes such as ##### and #DIV/0! are outlined, detailing their meanings and implications for calculations.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
47 views1 page

Excel 45

Chapter 3 discusses how to perform calculations on data in Excel and the importance of identifying and correcting errors in formulas. It explains the auditing process for finding errors, including the use of error codes and the Error button for assistance. Common error codes such as ##### and #DIV/0! are outlined, detailing their meanings and implications for calculations.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Chapter 3: Perform calculations on data

Find and correct errors in calculations


Including calculations in a worksheet gives you valuable answers to questions about
your data. As is always true, however, it’s possible for errors to creep into your formu-
las. With Excel, you can find the source of errors in your formulas by identifying the
cells used in a specific calculation and describing any errors that have occurred. The
process of examining a worksheet for errors is referred to as auditing.

Excel identifies errors in several ways. The first way is to display an error code in the
cell that contains the formula generating the error.

A warning triangle and pound sign indicate an error

When the active cell generates an error, Excel displays an Error button next to it.
Pointing to the button displays information about the error, and selecting the button
displays a menu of options for handling the error.

The following table explains the most common error codes.

Error code Description


##### The column isn’t wide enough to display the value.

#VALUE! The formula has the wrong type of argument, such as text in a cell where a
numerical value is required.

#NAME? The formula contains text that Excel doesn’t recognize, such as an unknown
named range.

#REF! The formula refers to a cell that doesn’t exist, which can happen whenever
cells are deleted.

#DIV/0! The formula attempts to divide by zero.

92

You might also like