Computer Tips – Formula errors in Excel

You are here: Home » tip of the day » Computer Tips – Formula errors in Excel

Posted on February 16, 2012 by iGennie Technical Services

excel-error We often make use of the Formula feature of a Microsoft Excel file to make our calculations and records more synchronized and less erroneous. But often while setting or using an Excel formula, we tend to make mistakes as formula is not evaluated and land up in certain errors that display on our screen leaving us confused. Here are few computer tips for you to relate to the errors when they occur and be cautious next time. Learn about the common error values that appears while creating a formula are discussed below:

Error	Description
#VALUE	This error value is displayed if you use a cell reference in a mathematical formula that contains a piece of text. This error also appears if a selection is used without specifying a function.
#DIV/0!	This error value is displayed if you divide a value by zero (O).
#REF!	This error value is displayed if cell reference does not exist that is used in the formula.
#N/A!	This error value is displayed if value is not available or Excel cannot find the required value.
Circular	The circular reference is a special error message displayed in form of dialog box.
Reference	This error message occurs when a formula uses its own result as one of its reference or arguments. This error message is also indicated in the status bar showing the cell address containing the error.

Leave a Reply Cancel reply