mercredi 22 février 2017

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)

Aucun commentaire:

Enregistrer un commentaire