IF column A contains ANY text OR IF column B contains ANY text.. [Closed]

Report
-
TrowaD
Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
-
Hello,

I'd like to achieve in Open Office Calc

IF column A contains ANY text then ADD "XYZ" into cell G12 OR
IF column B contains ANY text then ADD "ABC" into cell G12 OR
IF column C contains ANY text then ADD "QRS" into cell G12 OR
IF column D contains ANY text then ADD "TUV" into cell G12 OR
IF column E contains ANY text then ADD "DEF" into cell G12.

Thanks very much



Open Office Calc

1 reply

Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
Hi Pete,

You mean something like this?:
=IF(COUNTIF(A:A,"*")>0,"XYZ",IF(COUNTIF(B:B,"*")>0,"ABC",IF(COUNTIF(C:C,"*")>0,"QRS",IF(COUNTIF(D:D,"*")>0,"TUV",IF(COUNTIF(E:E,"*")>0,"DEF")))))

Best regards,
Trowa