Checking for empty cell in Excel
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
Technologies:
Actions: