excel if cell is blank then fill with text code example

Example: excel return 1 if cell looks blank

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

=--(A1="")