excel if cell empty take value from another 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="")