Errors in Formulas Errors in formulas are often the result of typing mistakes, calculations of invalid data, the wrong formatting, or reference to an invalid cell. You can correct an error by editing the cell containing the error. Error Meaning ##### The column is too narrow to display the result of the calculation. To fix change the width of the column #DIV/0! Divides a number by zero. In Excel this is invalid. NOTE: A blank cell is considered zero. #NAME? The formula contains a function name or cell reference Excel does not recognize. #VALUE! The formula refers to a cell that Excel cannot use in a calculation. #REF! The formula refers to a cell that is invalid.