Error: #DIV/0!

Why: #DIV/0! errors happen because your formula divides by zero. Oftentimes, you referenced a blank cell as the divisor by accident.

Example: The error occurs because cell B6 is empty, so Excel tried to divide by zero.

Solution: Correct this error by viewing your formula and ensuring the denominator is correct. In this case, the cell reference to B6
needs to change to being referenced to B5 instead. Excel can then divide by 3 instead of 0.