jeudi 27 octobre 2016

Nested If Excel

Can anybody help me figure out what am I doing wrong in the given nested If statement formula.

IF(COUNT(E2:F2)=0,"",IF(COUNT(E2:F2) =1 AND (F2="")),"",IF(COUNT(E2:F2)=2,E2,"Check")))

Aucun commentaire:

Enregistrer un commentaire