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 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_LewinSilver Contributor
Fernando,
if I understood correctly:
{=TEXTJOIN(" ",TRUE,IF(ISERROR(--LEFT(B2:F2))*(LEN(B2:F2)>9),B2:F2,""))}- Fernando SalgueiroCopper ContributorThank you very much