# Error Types in Formulas

If a formula in a cell cannot be calculated correctly, it means that the cell contains an **error**. The error appears because the formula's syntax is incorrect, or the formula uses unexpected arguments or data types.

Errors that occur in formulas are detailed in the following table:

Error | Description | Example |
---|---|---|

#DIV/0! |
Division by zero. | =A1/B1 (where the value in cell B1 is equal to zero, or cell B1 is blank) |

#NAME? |
The formula refers to a name that doesn't exist or is spelled incorrectly. | =SUM(Values) (the cell range named "Values" does not exist) |

#N/A |
The referenced value is not available to the formula. | =SUM(A1:A5*B1:B3) (the array formula has arguments consisting of different numbers of elements) |

#NULL! |
An incorrect range operator is used in the formula, or the specified intersection includes two ranges that do not intersect. | =SUM(A1 A3) (a colon is missing in the cell range reference) |

#NUM! |
There are invalid numeric values in the formula. | =SQRT(-4) (the square root of a negative number cannot be calculated) |

#REF! |
The cell reference is not valid. | =SUM(A1, B1) (column B has been deleted) |

#VALUE! |
The formula uses values of the incorrect data type. | =SUM(5, "Text") (the SUM function requires numeric arguments) |