Microsoft
Excel Errors
We face some errors during using MS excel. Today we discuss excel
error one by one.
Sr.
|
Error Name
|
Error
|
1
|
(Value Error)
|
#VALUE!
|
2
|
(DV/0 error) Division error
|
#DIV/0!
|
3
|
(name error)
|
#NAME?
|
4
|
(reference
error)
|
#REF!
|
5
|
((N/A!)finding
error)
|
|
6
|
(### number
error)
|
#N/A
|
7
|
(Null!
error)
|
#NULL
|
1 (Value Error)
#VALUE!
|
If we try to add alphabets like (a, b, c,) in numeric numbers
like (1, 2, and 3) etc. then excel display error known as value error… for
example adding text...
2 (Dv/0 error)
#D/V/0!
|
If we try to divide any value by zero in excel then excel
shows the error is division error.
3. (Name Error)
#NAME?
|
If we insert any incomplete or wrong formula then excel
display the error is known as name error.
4. (Reference error)
#REF!
|
If we try to apply a formula on a row or a column which is
not present or delete. In short if we give the wrong cell address then MS excel
display the reference error. In the below picture we delete column D after the
implementation of formula on D column so excel display error #REF!.
5. ((#N/A) Finding
error)
#N/A!
|
If we apply VLOOKUP formula and there is finding mistake in
it. So then an error occurs is finding error. In short we are trying to find
that which is not present in that document. This error present that value is
not in the table. VLOOKUP use to find specific value. If not in the table this
error displayed.
6. (### number error)
###
|
If we enter value in the cell and after entering the value if
we decrease the column width then this error displayed.
7. (Null! error)
#NULL!
|
If we press space instead of (+) sign in 2 values by adding
values in MS excel then MS excel display null error.
Video on youtube
