Is there a way with the =if function to have a blank (empty) produced
C Charles Williams Sep 29, 2009 #3 =IF(true,"","Not Blank") However in Excel blank is not the same as empty: there is no way to produce Empty from an IF statement regards Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com
=IF(true,"","Not Blank") However in Excel blank is not the same as empty: there is no way to produce Empty from an IF statement regards Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com
D Dee Sperling Sep 29, 2009 #4 Try this =IF(B1="","","There's data in that cell!") Hope this helps, Dee
