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="")
'Excel formula, returns 1 if cell looks blank and 0 otherwise:
=--(A1="")