=ISBLANK Help

[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?

 

[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

 

[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?

John

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

Regards
Peter