Forum Discussion
Fernando Salgueiro
Feb 15, 2018Copper Contributor
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...
- Feb 15, 2018
Fernando,
if I understood correctly:
{=TEXTJOIN(" ",TRUE,IF(ISERROR(--LEFT(B2:F2))*(LEN(B2:F2)>9),B2:F2,""))}
Detlef_Lewin
Feb 15, 2018Silver Contributor
Fernando,
if I understood correctly:
{=TEXTJOIN(" ",TRUE,IF(ISERROR(--LEFT(B2:F2))*(LEN(B2:F2)>9),B2:F2,""))}
- Fernando SalgueiroFeb 16, 2018Copper ContributorThank you very much