leav blank if null code example Example: excel return 1 if cell looks blank 'Excel formula, returns 1 if cell looks blank and 0 otherwise: =--(A1="")