• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

#NULL!

Excel displays the #NULL! error in a very specific case: When you use the intersection operator on two ranges that have no cells in common. Check your range coordinates to ensure that they're accurate. In addition, check to see if one of the ranges has been moved so that the two ranges in your formula no longer intersect.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint