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:
<tbody>
</tbody>
Here is an example of a cell:
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? |
<tbody>
</tbody>