We all make mistakes, but some of those mistakes are easier to recover from than others. If you create a formula that tries to have Excel divide a value by zero or use a value from a cell that’s currently blank, Excel will display an error flag indicating that it thinks you’ve made a mistake. If the error is that no value is in a cell you refer to in a formula, you can fix the problem by putting a value in that cell.
At times, though, Excel will identify a formula as an error when, in fact, it’s exactly what you intended. For example, if you create a worksheet that contains five columns of data, and you find the sum of each of those columns, Excel identifies the pattern inherent in those formulas. If you put a different type of formula (such as a formula that finds the maximum value in all five rows) in the cell next to those five consistent formulas, Excel will display an error indicating that the formula is inconsistent. Fortunately, you can choose to turn several types of error indicators on or off, saving you and your colleagues from worrying about errors that don’t exist.
18.219.249.210