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