=ISBLANK Help

J

John

The forumale im using is =ISBLANK(P6:R6)
However the number that im looking at are genarted from a
pivot table.

So even if one of them is blank it still says False when
it should be true

Any ideas?
 
F

Frank Kabel

Hi John
ISBLANK will only test ONE cell (the first in your range). If in your
case you may use
=COUNTBLANK(P6:R6)>0
 
P

Peter Atherton

-----Original Message-----
The forumale im using is =ISBLANK(P6:R6)
However the number that im looking at are genarted from a
pivot table.

So even if one of them is blank it still says False when
it should be true

Any ideas?
Click to expand...

John

IsBlank can only refer to one cell, use someting like this
=IF(AND(ISBLANK(C26),ISBLANK(C27)),TRUE,FALSE)

Regards
Peter
 
Top