IF column A contains ANY text OR IF column B contains ANY text..

[Closed]
Report
-
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
-
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
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!