Formula Mistake in Excel
While working in excel and using formula, we often commit mistakes. Therefore the formula is not calculated and excels gives error messages.
When creating a formula, it is possible a mistake may commit. The formula is not calculated and Excel displays an error value or message. Error values that showed while making formula are illustrated below:
#VALUE
Value error appears when you write cell reference in a mathematical formula with text. This error also displays when choices are made without defining a function.
#DIV/0!
DIV/0 error appears when you divide a value by zero (O).
#REF!
REF error appears when cell reference does not match with the formula.
#N/A!
N/A error appears when value is unknown for Excel.
Circular Reference
The circular reference is a particular error message appears in dialog box. This error message comes when a formula interprets its own outcomes. This error message is also appeared on the status bar, pointing the cell address having error.
