=if blank cell

[FAZO]

Is there a way with the =if function to have a blank (empty) produced

 

[Mike H]

Hi,

=IF(A1="Something",B1,"")

Mike

 

[Charles Williams]

=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

 

[Dee Sperling]

Try this

=IF(B1="","","There's data in that cell!")

Hope this helps,
Dee