problem with ISBLANK

  • Thread starter Thread starter CJ
  • Start date Start date
C

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
 
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.
Click to expand...

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")
 
Back
Top