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:

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)