If any cell in a range has a value, return "True"
 

I am looking for a formula that, if any cell in a range has a value, will
return "True", and if all blank, return "False".
Thank you.

If any cell in a range has a value, return "True"
 

On Thu, 16 Jul 2009 12:26:11 -0700, raystub
wrote:

I am looking for a formula that, if any cell in a range has a value, will
return "True", and if all blank, return "False".
Thank you.


Try this formula:

=COUNTA(myrange)0

or, if you don't have a named range

=COUNTA(A1:D10)0

where A1:D10 is the range in question.

Hope this helps / Lars-Åke