CODEWITHSUNDEEP
excelif-statementcountexcel-formulanotnull
Boosted_d16
Boosted_d16

Reputation: 14062

excel formula: return true if none of the cells in the range are blank

I want to return true if a range of cells (A2:K2) doesnt contain any blanks. So all the cells in the given range must contain something.

I can count the number of cells that contains something but im not sure what to do next?

=SUMPRODUCT((LEN(A2:K2)>0)*1)

Upvotes: 0

Views: 1377

Answers (1)

Jordan
Jordan

Reputation: 4514

Use COUNTBLANK to count the blank cells in conjunction with an IF formula:

=IF(COUNTBLANK(A2:K2)=0,TRUE,FALSE)

Upvotes: 3

Related Questions