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

[raystub]

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.

 

[Lars-Åke Aspelin]

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(A110)>0

where A110 is the range in question.

Hope this helps / Lars-Åke