ExcelBanter - =if blank cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =if blank cell (https://www.excelbanter.com/excel-discussion-misc-queries/244011-%3Dif-blank-cell.html)

FAZO

=if blank cell

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

Mike H

=if blank cell

Hi,

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

Mike

"FAZO" wrote:

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

Charles Williams

=if blank cell

=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

"FAZO" wrote in message
...
Is there a way with the =if function to have a blank (empty) produced
--
fAZO

Dee Sperling[_2_]

=if blank cell

Try this

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

Hope this helps,
Dee

"FAZO" wrote:

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

All times are GMT +1. The time now is 05:55 AM.