Following formula can be used to check for empty cells and then do something based on the return.

=if(A1 = "", 0, 1)

If the cell A1 is empty, print 0 else print 1.

Note that "" is not null but empty Note that a seemingly empty cell with formula is not empty