Lesson#134: Excel errors and why it shows

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 different types of errors and why it shows.

What is #DIV/0! in Excel?

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

What is #N/A in Excel?

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

What is #NAME? in Excel?

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

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

What is #NULL! in Excel?

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

Excel errors and why it shows

What is #NUM! in Excel?

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

Excel errors and why it shows

What is #REF! in Excel?

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

Excel errors and why it shows

What is #VALUE! in Excel?

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

Excel errors and why it shows

What is the IFERROR function?

See also  Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE

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.

0 Comments on “Lesson#134: Excel errors and why it shows

Leave a Reply

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

*