Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Silverlight


In some cases formula values may return errors. For example, it might have happened that you entered an invalid algebraic expression, or maybe you are referencing a cell that does not exist. The specific error value which is returned can hint the cause of the issue and, therefore, facilitate the process of finding a solution.

The following table contains information about all supported errors.

#DIV/0! Divide by Zero Error occurs when the formula contains an expression that results in division by zero. For example, such error is produced when the following expression is calculated: =5/0.
#VALUE! Error in Value occurs when an argument is not of the correct type. For example, passing the ABS function (ABS function returns the absolute value of a number) a text value as an argument (which is not a text number representation, such as "5") produces the #VALUE! error: =ABS("string").
#REF! Reference Error implies that the referenced cell does not exist (e.g. ABCDE1) or has been deleted.
#NAME? Invalid Name Error indicates that the cell value contains a name of an unknown function or variable. For example, attempt to use a function that is not in the built-in functions list will produce the #NAME? error: =ABCDEF(). Another case that will produce the error is use of undefined name.
#NUM! Number Error indicates that the number does not meet function requirements. For example, passing the LN function (LN function returns the natural logarithm of a number) a negative number as argument produces #NUM! error: =LN(-10).
#N/A Value Not Available Error occurs when a function cannot produce a valid output. For example, passing the MODE function (MODE function returns the most frequently occurring or repetitive value in an array or range of data) the arguments 1, 2, 3 will cause the #N/A error because each of the numbers appears exactly once and, therefore, the set of numbers does not have a mode: =MODE(1,2,3).
#NULL Null Error occurs when the two cell ranges passed to an intersection operator do not intersect. For example, the value =A1:A2 B1:B2 returns null error since the two ranges to not have cells in common.
In this article
Not finding the help you need? Improve this article