if cell is empty then use another cell code example

Example: excel return 1 if cell looks blank

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

=--(A1="")