Excel - Not null

Asked By GaryFShelto on 26-Dec-07 08:09 PM
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




demechani replied on 26-Dec-07 08:28 PM
Maybe one of these:
=if(ISBLANK(A1),"Blank","Not Blank")
=if(A1="","Null","Not Null")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
joeu2004 replied on 27-Dec-07 05:47 AM
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).
Don Guillett replied on 27-Dec-07 09:35 AM
=IF(LEN(TRIM(C15))=0,"",1)


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