excel if cell not empty code example

Example 1: excel check if cell not empty

IF(A1<>"","Not empty","Empty")

Example 2: excel vba check cell not empty

'VBA to check if cell A1 has a value.

'Two different ways...

MsgBox Not IsEmpty([A1])

MsgBox Not Len([A1]) = 0

Example 3: HOW TO SAY IF A CELL IS NOT EMPTY INEXCEL

=IF(D5<>"","Done","Not done")

Example 4: excel return 1 if cell looks blank

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

=--(A1="")