Forum Discussion

Fernando Salgueiro's avatar
Fernando Salgueiro
Copper Contributor
Feb 15, 2018
Solved

IF Statement for Multiple conditions returning the wrong results

I am trying to get a formula to check if B2 have the first 3 letter and have more than 9 characters if yes check C2 for the same logic if yes add B2&" "&C2 and check D2, if yes add D2 and check e3 and f2. the problem is some of the false statement is returning a false number. See. below the last row it will be form as 3Word & 4Word & 5Word but my if is adding 2word that does not match the ifs

  • Fernando,

     

    if I understood correctly:

    {=TEXTJOIN(" ",TRUE,IF(ISERROR(--LEFT(B2:F2))*(LEN(B2:F2)>9),B2:F2,""))}

     

     

     

     

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Fernando,

     

    if I understood correctly:

    {=TEXTJOIN(" ",TRUE,IF(ISERROR(--LEFT(B2:F2))*(LEN(B2:F2)>9),B2:F2,""))}