Formula Error in Excel - You should Know

Excel formula help you to do lengthy calculation easily but for that you should know exact formula.
Arguments which use in formula should be correct to get correct answer. If we type wrong formula or argument then we get wrong answer and most probably ERROR.

There are mainly four types are error occur when we type wrong formula -

Lets understand how error comes and what we need to do to resolve them.


1. #VALUE!  ERROR

Value error occurred when formula has wrong type of argument means when you want total
of numbers but text is included in number then excel displays Value error.

Error

Solution

Solution – Simply remove wrong argument from formula.

2. #DIV/0! ERROR

DIV error displays when you divided any cell or number with 0. This is simple math rule. You can not divide any number with zero.

Error

Solution

 Solution - Change zero to another number

3. #REF! ERROR

REF errors displays when excel unable to find cell reference. Generally this error displays when
you deleted some row / column from sheet which used in formula.

Error

Solution

Solution – Remove #REF! from formula and / or add proper reference in formula.

4. #NAME? ERROR

NAME error displays when excel does not recognize text in formula. If you have mentioned
wrong range name or function name is incorrect then NAME error occurred.

Wrong name range -

Error

Solution

Wrong function - 

 

Error

Solution

Solution - Correct formula or remove unrecognized text from formula

Hope you understand. Feel free to comment if you have any doubt.

Watch Video - 

Thank you. Have a nice day. Enjoy Excelling