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.

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

--
Gary''s Student - gsnu200811

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" wrote:

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.

Hmm,

No need for the count bit.

Mike

"Mike H" wrote:

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" wrote:

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.

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

"Mike H" wrote:

Hmm,

No need for the count bit.

Mike

"Mike H" wrote:

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" wrote:

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.