Home > Forum Home > Presenting and Reporting Data > IS NOT NULL Formula > Empty cell formulas Share

Empty cell formulas

Excel Help for Empty Cell Formulas in Presenting and Reporting Data


Forum TopicLogin

Empty Cell Formulas

Rate this:
(3/5 from 1 vote)
OopsFor 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Empty cell formulas in the