I am trying to get the formula that says "IF this cell contains this OR that" however there are 3 conditions.
Here is an example of a cell:
[TABLE="width: 389"]
<tbody>[TR]
[TD="width: 389"]PLT-NA-NA|CIG-NA-NA|GLD-NCORP-A|BSC-NCORP-A
I have the first part of the formula: =IF(SUM(COUNTIF(A26,"*"&{"PLT-NCORP","PLT-CORP"}&"*")),"PLT","GLD")
However, there is a third condition. If PLT-NA-NA, and GLD-NA-NA, then the value should be NA.
How would I add this third part to the formula?
[/TD]
[/TR]
</tbody>[/TABLE]
Here is an example of a cell:
[TABLE="width: 389"]
<tbody>[TR]
[TD="width: 389"]PLT-NA-NA|CIG-NA-NA|GLD-NCORP-A|BSC-NCORP-A
I have the first part of the formula: =IF(SUM(COUNTIF(A26,"*"&{"PLT-NCORP","PLT-CORP"}&"*")),"PLT","GLD")
However, there is a third condition. If PLT-NA-NA, and GLD-NA-NA, then the value should be NA.
How would I add this third part to the formula?
[/TD]
[/TR]
</tbody>[/TABLE]