=ISBLANK Help

  • Thread starter Thread starter John
  • Start date Start date
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?
 
Hi John
ISBLANK will only test ONE cell (the first in your range). If in your
case you may use
=COUNTBLANK(P6:R6)>0
 
-----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
 
Back
Top