Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Isblank
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Isblank
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Isblank
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IsBlank | Excel Discussion (Misc queries) | |||
IF and ISBLANK | Excel Worksheet Functions | |||
IF AND ISBLANK | Excel Worksheet Functions | |||
ISBLANK() | Excel Worksheet Functions | |||
If(ISBLANK) | Excel Worksheet Functions |