IF + OR formula

[amp7394]

What would be the correct formula for IF a cell contains text x OR contains text Y, then give me Z value. Right now I have:

=IF(SUM(COUNTIF(A6,{"BSC-NCORP-A","BSC-CORP-A"})),"BSC","CIG")

But I am only getting the CIG value for everything.

 

[Aryatect]

Hi, I think below should work:

Book1
	A	B
5	BSC-NCORP-A	BSC
6	BSC-NCORP-B	BSC
7	BSC-NCORP-C	CIG
Sheet4

Cell Formulas
Range	Formula
B5	=IF(OR(A5="BSC-NCORP-A",A5="BSC-NCORP-B"),"BSC","CIG")

 

[amp7394]

Hi, thank you for your response. I am actually only asking Excel to look for a portion of the cell. The entire A5 cell says: [TABLE="width: 389"]
<tbody>[TR]
[TD="width: 389"]BSC-NCORP-A|PLT-NA-NA|CIG-NA-NA|GLD-NCORP-L

So, IF A5 contains BSC-NCORP-A or BSC-CORP-A, then BSC, if not CIG.

How would I edit the formula so that its only asking to look portion of text in the cell?[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, see below additions in red to you original formula.

=IF(SUM(COUNTIF(A6,"*"&{"BSC-NCORP-A","BSC-CORP-A"}&"*")),"BSC","CIG")