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 an...
  • Detlef_Lewin's avatar
    Feb 15, 2018

    Fernando,

     

    if I understood correctly:

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