Hi,

I'd like to test whether there are any blank cells in range of cells I have.
If there are blank cells in the range I'd like them to return "False" and if
there's something in the range I'd like them to return "True"

The cells I'm checking is text.
I've tried the formula =ISBLANK(C6:H6) but it doesn't seem to work
Can anyone help?

Thanks,
L

Hi,

This will rteurn false if there are any blanks in the range

=NOT(COUNTBLANK(A1:A10)0)

Mike

"Lishen" wrote:

Hi,

I'd like to test whether there are any blank cells in range of cells I have.
If there are blank cells in the range I'd like them to return "False" and if
there's something in the range I'd like them to return "True"

The cells I'm checking is text.
I've tried the formula =ISBLANK(C6:H6) but it doesn't seem to work
Can anyone help?

Thanks,
L

Hello Lishen,

Try this:

=IF(COUNTIF(C6:H6,"")=1,"False","True")

Judith
--
Hope this helps


"Lishen" wrote:

Hi,

I'd like to test whether there are any blank cells in range of cells I have.
If there are blank cells in the range I'd like them to return "False" and if
there's something in the range I'd like them to return "True"

The cells I'm checking is text.
I've tried the formula =ISBLANK(C6:H6) but it doesn't seem to work
Can anyone help?

Thanks,
L