Microsoft Office/Troubleshooting Excel Errors
Common sources of errors are parentheses that don’t match or missing arguments for functions. If your formula is free from those errors, here are some error values you might get:
|######||There is nothing wrong with your formula; the cell simply isn’t big enough to display the result. Widen the column. or set "Shrink to fit" under Alignment.|
|#DIV/0||You are trying to divide by zero
|#NAME?||There is a name in the formula that Excel doesn’t recognize.
|#REF!||A cell reference is not valid. Reenter the formula.|
|#VALUE!||The formula uses the wrong type of operand or argument. Check to see that you’re not performing math operations on labels or that arguments of functions that need to numeric are not referring to cells containing labels.|
A handy function to avoid errors is ISERR. For example, to divide one column by another, where blanks and zeros are present, use this formula (in cell C1): =IF(ISERR(A1/B1),"",A1/B1)Last modified on 28 September 2010, at 14:46