Not null

  • Thread starter Thread starter Gary F Shelton
  • Start date Start date
G

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")
 
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.
Click to expand...

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).
 
Back
Top