#DIV/0! Error Solution

Home Forums Cell Errors #DIV/0! Error Solution

This topic contains 0 replies, has 1 voice, and was last updated by Avatar Neil Parsont 5 years, 9 months ago.

  • Author
    Posts
  • #911
    Avatar
    Neil Parsont
    Keymaster
    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.
    
    
    DIV 0 Error

You must be logged in to reply to this topic.