IS NOT NULL Formula

Excel Help for Is Not Null Formula in Presenting and Reporting Data

Is Not Null Formula

Rate this: (3/5 from 1 vote)

	IF(c3=IS NOT NULL,1,0) what is the code for "IS NOT NULL"?  IS IT ""?
	Posted by KathyKo1 on 22 Jul 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Empty cell formulas Rate this: (3/5 from 1 vote) For empty cells you can use IF(C3<>"",1,0).  There is also the BLANK formula which returns TRUE or FALSE. However, if the cell contains a 0 (zero) then you may want to add another test to the formula with and AND directive. You can also look at the "Information" category of functions in Excel which return details such as errors and data types.
	Excel Business Forums Administrator
	Posted by Excel Helper on 22 Jul 2010

Displaying page 1 of 1