Excel 2007 : How to check if a range contains any blank cells?

[The_Snook]

Hi,

I'm currently using this formula but surely there's a better way of achieving the same goal?

=IF(OR(ISBLANK(B2),ISBLANK(C2),ISBLANK(D2),ISBLANK(E2),ISBLANK(F2),ISBLANK(G2),
ISBLANK(H2),ISBLANK(I2),ISBLANK(J2),ISBLANK(K2),ISBLANK(L2)),"Yes","No")

Thanks,

Snook

[acallidus]

=IF((COLUMN(A1)-COLUMN(L1))>(COUNT(A1:L1));"Blank cells exists";"There is no blank cells")

[arthurbr]

Perhaps

=if(countblank(B2:L2),"yes","no")