Two types of blank in Excel

I have encountered two types of blank in Excel. The first, when you do =(the blank cell) in another cell, gives 0; the second gives blank.   The first, when you do =(the blank cell)+1 gives 1; the ...