IF Statement for Cells in a Range

  • Thread starter Thread starter Confused_in_Houston
  • Start date Start date
C

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.
 
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
 
Hmm,

No need for the count bit.

Mike

Mike H said:
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
Click to expand...
 
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
 
Back
Top