 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Not 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")  SignatureGS Maybe one of these: =if(ISBLANK(A1),"Blank","Not Blank") =if(A1="","Null","Not Null") SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > 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 [quoted text clipped - 3 lines] > I would think the statement would be something like =if(A1=Not Null,"Not > Null,"Null") On Dec 26, 5:09 pm, Gary F Shelton <GaryFShel...@discussions.microsoft.com> wrote: > 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). =IF(LEN(TRIM(C15))=0,"",1) SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >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 [quoted text clipped - 4 lines] > I would think the statement would be something like =if(A1=Not Null,"Not > Null,"Null")
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.