#NULL! Error Solution

Home › Forums › Cell Errors › #NULL! Error Solution

Viewing 0 reply threads
  • Author
    Posts
    • January 21, 2016 at 11:09 AM #907
      Neil Parsont
      Keymaster
      Error: #Null!

Why: #Null! errors happen when a "space" is used by accident instead of a comma or colon. The "space" in an Excel formula
is an operator telling Excel to find the intersection of two ranges. When there is no intersection, Excel returns #NULL!.

Example: Typing =SUM(A1:A3 B1:B3) will return the #NULL! error because there is a space in the formula.

Solution: Replace the "space" with a comma.

Null Error
      Attachments:

      1. FBLogo.png

      2. FB-image-post.png

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.