excel how to if cell is empty use first non empty cell code example

Example 1: excel check if cell not empty

IF(A1<>"","Not empty","Empty")

Example 2: excel return 1 if cell looks blank

'Excel formula, returns 1 if cell looks blank and 0 otherwise:

=--(A1="")