Excel - Not null

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")
--
GS

Maybe one of these:
=if(ISBLANK(A1),"Blank","Not Blank")
=if(A1="","Null","Not Null")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

On Dec 26, 5:09=A0pm, Gary F Shelton

I would use:

=3Dif(A1=3D"", "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).

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com