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

Closed
Pete - Mar 6, 2016 at 08:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 8, 2016 at 11:26 AM
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
Related:

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Mar 8, 2016 at 11:26 AM
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
0