correct common errors in excel formulas

Posted on: November 3, 2009 | By: Elite | Filed under: Tech Tips

Did you know that you can implement certain rules to check for errors in formulas when using Microsoft Excel? These rules can help you find common mistakes when using formulas and these rules can be turned on or off individually.

Errors can be marked and corrected in two ways: one error at a time or immediately when they occur on the worksheet as you work. Either way, a triangle appears in the top-left corner of the cell when an error is found.

clip_image001

Errors that cannot return a result (such as dividing a number by zero) require attention and display an error value in the cell. Other errors can be less serious, such as a formula that appears to be inconsistent with adjacent formulas. The formula returns a correct result, but the error advises you that you should examine the formula.

You can resolve an error by using the options that appear or you can ignore the error by clicking Ignore Error. If you ignore an error in a particular cell, the error in that cell does not appear in further error checks. However, you can reset all previously ignored errors so that they appear again.

To find out more about checking common errors in excel and how to turn these rules on or visit Microsoft Office Online.

 

Comments are closed.