Not null

[Gary F Shelton]

I want to write a statement to check a series of rows in a column to see if
it has data. If it has data then I want to return a statement that says Not
Null and if the statement is blank... well you guessed it I want it to say
Null.

I would think the statement would be something like =if(A1=Not Null,"Not
Null,"Null")

 

[Max]

Maybe one of these:
=if(ISBLANK(A1),"Blank","Not Blank")
=if(A1="","Null","Not Null")

 

[joeu2004]

I want to write a statement to check a series of rows in a
column to see if it has data. If it has data then I want to return
a statement that says Not Null and if the statement is blank...
well you guessed it I want it to say Null.

I would use:

=if(A1="", "Null", "Not Null")

This works whether A1 is truly empty (does not contain a formula or
value) as well as if A1 appears empty because it has a formula that
results in the null string ("").

ISBLANK() is true only if the cell is truly empty (no formula or
value).

 

[Don Guillett]

=IF(LEN(TRIM(C15))=0,"",1)