IF Statement for Cells in a Range

[Confused_in_Houston]

I have a spreadsheet that's 20 columns wide. I make entries under each
heading dependiing upon the relationship of the heading topic and the data in
column A. But there are times when no data is entered and B:U is completely
unpopulated. I would like to write an if statement that says IF(B:U has no
entries, "value1", "value2").

I just don't know the term to use for "if the range is completely unpopulated"

Thanks.

 

[Gary''s Student]

=IF(COUNTA(B:U)=0,"value1","value2")

 

[Mike H]

Hi,

You didn't say what you put in the range so this checks for text and numbers

=IF(AND(COUNT(B2:U14)=0,COUNTA(B2:U14)=0),"Its Empty","We got data")

Mike

 

[Mike H]

Hmm,

No need for the count bit.

Mike

Hi,

You didn't say what you put in the range so this checks for text and numbers

=IF(AND(COUNT(B2:U14)=0,COUNTA(B2:U14)=0),"Its Empty","We got data")

Mike

 

[Confused_in_Houston]

Some cells have numbers, some have text. I'm sorry what does it mean to
forget the count bit? How does that impact the formula in your previous post?

Thanks