How to check a cell that is not blank

[Etphonehome]

Hi,

I got a newbie question, how to set a formula to check a cell that is blank (assume that cell has no formula in it).

And what formula should be used if the cell has formula but the result is blank ?

Thanks,
Et

 

[Aladin Akyurek]

Hi,

I got a newbie question, how to set a formula to check a cell that is blank (assume that cell has no formula in it).

And what formula should be used if the cell has formula but the result is blank ?

Thanks,
Et

=IF(A1="","",1)

checks whether A1 is empty (unused) or houses a blank, as result of a formula. If enpty/blank, we get a blank, otherwise 1 as result.

 

[shift-del]

Hi,

I got a newbie question, how to set a formula to check a cell that is blank (assume that cell has no formula in it).

And what formula should be used if the cell has formula but the result is blank ?

Thanks,
Et

If you have to distinguish between those cases, have a look at this.

<table valign="middle" colspan="3" style="font-family:Calibri; color:#000000; background-color:#FFFFFF; font-size:11px; font-weight:normal; font-style:normal; " border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="60pt"><col width="133,5pt"></colgroup><tbody><tr style="background-color:#FAFAFA"><td colspan="3" align="center">Worksheet 'Tabelle1'</td></tr><tr style="background-color:#cacaca"><td>
</td><td align="center">A</td><td align="center">B</td></tr><tr><td style="background-color:#cacaca" align="center">1</td><td align="right">
</td><td align="left">Cell has no content.</td></tr><tr><td style="background-color:#cacaca" align="center">2</td><td align="left">
</td><td align="left">Cell has blank content</td></tr><tr><td style="background-color:#cacaca" align="center">3</td><td align="right">555</td><td align="left">Cell has non-blank content.</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Calibri; font-size:10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40pt"><col></colgroup><tbody><tr style="background-color:#eeaaaa"><td>Cell</td><td>Formula</td></tr><tr><td>A2</td><td>=""</td></tr><tr><td>B1</td><td>=CHOOSE(ISBLANK(A1)+(A1="")+1,"Cell has non-blank content.","Cell has blank content","Cell has no content.")</td></tr></tbody></table><table style="font-family:Arial; font-size:7pt"><tbody><tr><td style="color:#333333">Created with Tab2HTML (v2.4.1). ©Gerd alias Bamberg</td></tr></tbody></table>

 

[Etphonehome]

Thanks a lot.

 

[Etphonehome]

How many parameter can a CHOOSE have?

I have never used Choose, looks very useful, thanks for sharing

 

[Aladin Akyurek]

How many parameter can a CHOOSE have?

I have never used Choose, looks very useful, thanks for sharing

See "limits" in the Help of your version.

 

[shift-del]

I have never used Choose, looks very useful, thanks for sharing

CHOOSE() is one of three power functions.
The others are LOOKUP() and INDEX().

 

[T. Valko]

How many parameter can a CHOOSE have?

I have never used Choose, looks very useful, thanks for sharing

In Excel 2007 and later you can have up to 254 value arguments.

In Excel 2003 and earlier you can have up to 29 value arguments.