Scribd
Upload
16 views13 pages

Excel Errors

Uploaded by

shiba.amiry2025
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
16 views13 pages

Excel Errors

Uploaded by

shiba.amiry2025
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
You are on page 1/ 13

ERRORS IN MS-EXCEL

MBA I
SECTION B
GROUP-5
COMMON ERRORS IN MS
EXCEL

The following table shows Excel’s error values along


with the meaning and the most probable cause for its
appearance.

To remove an error value from a cell you need to figure


out what’s wrong with the formula and fix it.
Common Error Messages

 ##### Cell isn’t wide enough to show the


data.
 #VALUE! Wrong type of data for a
function.
 #DIV/0! Tried to divide by zero.
 #NAME? Cell name not defined or
(usually) misspelled.
 #REF! Cell reference is not valid.
 #NUM! Function requires a number.
 #NULL! Called a non-intersecting range of
cells.
 #N/A No value available.
#####
 MEANING-
-This column is not wide enough to display the
value i.e. the cell is too small for the value.

 FIXES-
-Widen the column.
#VALUE!
 MEANING-
-wrong type of argument.
-Wrong type of data for a function.
-Something wrong with the input to a formula.

 FIXES-
-check operands & arguments and make sure
references are valid.
#DIV/0
 MEANING-
-formula is attempting to divide by zero.
-The division operation in your formula refers to a
cell that contains the value 0 or is blank.

 FIXES-
-change the value or cell references so that the
formula does not divide by zero.
#NAME?
 MEANING
-formula is referencing an invalid or non-existent
name.
-Cell name not defined or (usually) misspelled.

 FIXES-
-make sure the name still exists or correct the
spelling.
#REF!

 MEANING-
excel cannot locate the referenced cells(for
example, referenced cells are deleted)
cell references are invalid.

 FIXES-
click UNDO immediately to restore reference and
then change the formula references or convert
formulas to values.
#NUM!
 MEANING-
-Incorrect use of a number(such as sort(-1)) , or
formula results in a number too large or too small to
be displayed.
-Function requires a number.

 FIXES-
-make sure that the arguments are correct and that
the result is between -1*10 307 power.
#NULL!
 MEANING-
-references to intersection of two areas that do not
intersect.
-Called a non-intersecting range of cells.

 FIXES-
-check for typing and reference errors.
#N/A
 MEANING-
-most commonly means no value is available or
inappropriate arguments were used.
- no value available.

 FIXES-
-In a look up formula , be sure the look up table is
sorted correctly.
CORRECTING ERRORS:
Errors in Data and Formulas
 To fix bad data, click on the cell and retype the
number.
 To fix bad formulas, click the cell containing the
formula, then
 highlight the error in the formula bar and make
corrections.

Excel Error Messages


 The program can help spot errors.
 Excel error messages begin with “#”.
TEAM

 NAMRATA CHHABRA
 POOJA SETH
 NIKITA ARORA
 SANCHI KATARIA
 PRIYANKA

You might also like