problem with ISBLANK

[CJ]

Hi, I' m having a problem using isblank on multiple cells it seem only to
work on a single cell.
I'm looking for a formula to return a value of OK if the range of cells
G50:G100 are all blank and a value of NO if there is Something in any of the
cells. The something can be either alplha statement or a number. Is there
a way to do this any help would be appreciated.
Thanks in advance
Chris

 

[Nicky]

Hi Chris
looks like you need countblank
try
=IF(COUNTBLANK(G50:G100)=51,"OK","No"

 

[Leo Heuser]

Hi Chris

One way:

=IF(COUNTIF(G50:G100,"<>"),"No","Yes")

 

[Harlan Grove]

Hi, I' m having a problem using isblank on multiple cells it seem only to
work on a single cell.
I'm looking for a formula to return a value of OK if the range of cells
G50:G100 are all blank and a value of NO if there is Something in any of the
cells. The something can be either alplha statement or a number. Is there
a way to do this any help would be appreciated.

Two suggestions to use complicated kinds of counting when simple counting is all
that's needed. If you're tyring to use ISBLANK, then you seem to check for truly
blank cells, i.e., no contents whatsoever. If so, you could use

=IF(COUNTA(G50:G100),"NO","OK")