If a formula cannot correctly evaluate a result, Excel displays an error value, such as # # # # #, #DIV/0!, #N/A, #NAME?, #NULL!, and #VALUE!. Each error type has different causes, ad different solutions.

The following table contains links to articles that describe these errors in detail, and a brief description to get you started.

Error Value  Description

#####                               Excel displays this error when a column is not wide enough to display all the characters in a cell, or a cell contains a negative date or time value.

#DIV/0!                             Excel displays this error when a number is divided either by zero (0) or by a cell that contains no value.

#N/A                                   Excel displays this error when a value is not available to a function or formula.

#NAME?                             This error is displayed when Excel does not recognize text in a formula.

#NULL!                               Excel displays this error when you specify an intersection of two areas that do not intersect (Cross). The intersection operator is a space character that separates references in a formula.

#NUM!                                 Excel displays this error when a formula or function contains invalid numeric values.

#REF!                                     Excel displays this error when a cell reference is not valid.

#VALUE!                                Excel can display this error if your formula includes cells that contain different data types.

By admin

Leave a Reply

Your email address will not be published.