Lesson#134: Excel errors and why it shows

We know about errors in excel. We face different types of errors when working in excel. Today I will discuss about different types of errors and why it shows.

#DIV/0!

It’s meaning is division by zero. When a value is divided by 0 (zero) or a blank cell then it shows a error #DIV/0!

#N/A

It’s meaning is no value available. This error shows when the formula doesn’t have the required value entered in cells from where it takes reference.

#NAME?

It shows when excel doesn’t recognize a name or when you incorrectly enter range or when you enter a incomplete formula.

See the formula is incorrectly typed VLOKUP instead of VLOOKUP so it shows a #NAME? error.

#NULL!

This error occurs when you insert space instead of comma between ranges (
which doesn’t intersect) during function operation.

#NUM!

This error occurs when a formula gives a result of too big number that is not possible to represent in worksheet.

#REF!

This error occurs when any cell reference in a formula gets deleted.

#VALUE!

This error occur when you input a wrong type argument or operator in function.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*