Check if range of cells is empty, AND does not contain formula

[noslenwerd]

Hello,

Having issues finding a formula that checks is a range is empty, AND does not have a formula in it.

For instance... I want A1 to show "Project Title" IF there are ANY values in A2:A7. Otherwise it would be blank.

Thank ahead of time!

 

[Fluff]

How about
=IF(COUNTBLANK(A2:A7)=6,"","Project title")

 

[DanteAmor]

Try

=IF(COUNTA(A2:A7),"Project Title","")

 

[noslenwerd]

Try

=IF(COUNTA(A2:A7),"Project Title","")

Thanks for the reply, but this doesnt work. If I erase the formulas from a2:a7, it works. But anytime a formula is present, it shows up as not blank.

 

[DanteAmor]

I guess I misunderstood. According to your requirement, 2 conditions must be met:
1. That the cells are empty.
2. And that the cells have no formulas.

Having issues finding a formula that checks is a range is empty, AND does not have a formula in it.

If you only want to check if the cells are empty, then it is only a condition. So Fluff's formula is correct.