Can anyone see where this formula is going wrong? It won't accept it. I tried changing the parenthesis but still wont accept. Appreciate your help on this.
IF(D2="ATLAS",CONCATENATE(G2,LEFT(E2,6),
IF(D2="DOGS",CONCATENATE((G2,LEFT(E2,6)),
IF(D2="GCS",CONCATENATE(G2,LEFT(E2)),
IF(D2="IOWA",CONCATENATE((G2,MID(H2,7,4),RIGHT(H2,1)),
IF(D2="RADAR",CONCATENATE(G2,CE,AC))))))
Bookmarks