vendredi 13 juillet 2018

excel IF formula Error, "You've entered too many arguments"

Can someone help with this? It says, "You've entered too many arguments for this function", but works if I remove two lines.

=IF(IF(AND(J7<>"",IFERROR(MATCH(J$3, C7:F7, 0), "")<>""), IFERROR(MATCH(J$3, C7:F7, 0), ""),    
IF(AND(K7<>"",IFERROR(MATCH(K$3, C7:F7, 0), "")<>""), IFERROR(MATCH(K$3, C7:F7, 0), ""),    
IF(AND(L7<>"", IFERROR(MATCH(L$3, C7:F7, 0), "")<>""), IFERROR(MATCH(L$3, C7:F7, 0), ""),    
IF(AND(M7<>"", IFERROR(MATCH(M$3, C7:F7, 0), "")<>""), IFERROR(MATCH(M$3, C7:F7, 0), ""),    
IF(AND(N7<>"", IFERROR(MATCH(N$3, C7:F7, 0), "")<>""), IFERROR(MATCH(N$3, C7:F7, 0), ""),    
IF(AND(O7<>"", IFERROR(MATCH(O$3, C7:F7, 0), "")<>""), IFERROR(MATCH(O$3, C7:F7, 0), ""),    
IF(AND(P7<>"", IFERROR(MATCH(P$3, C7:F7, 0), "")<>""), IFERROR(MATCH(P$3, C7:F7, 0), ""),    
IF(AND(Q7<>"", IFERROR(MATCH(Q$3, C7:F7, 0), "")<>""), IFERROR(MATCH(Q$3, C7:F7, 0), ""),    
IF(AND(R7<>"", IFERROR(MATCH(R$3, C7:F7, 0), "")<>""), IFERROR(MATCH(R$3, C7:F7, 0), ""),    
IF(AND(S7<>"", IFERROR(MATCH(S$3, C7:F7, 0), "")<>""), IFERROR(MATCH(S$3, C7:F7, 0), ""),    
IF(AND(T7<>"",IFERROR(MATCH(T$3, C7:F7, 0), "")<>""), IFERROR(MATCH(T$3, C7:F7, 0), ""),    
IF(AND(U7<>"",  IFERROR(MATCH(U$3, C7:F7, 0), "")<>""),IFERROR(MATCH(U$3, C7:F7, 0), ""), ""))))))))))<>"", TRUE, FALSE)

Aucun commentaire:

Enregistrer un commentaire