Nested If Excel

Question

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")))

Answer 1

As @ScottCraner commented, you probably intended to use the AND function.

Do it this way:

AND(condition1,condition2)

not

condition1 AND condition2 <-BAD

Using the adjusted syntax:

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