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:

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?

<tbody>
</tbody>

 

[FormR]

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

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