excel find next non blank cell in column code example

Example: excel return 1 if cell looks blank

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

=--(A1="")