How can I add a wildcard to my if formula that also contains an or condition

Question

I have a column of locations on an Excel file, and some of the locations can be named something like this

In other words, I want my formula to add a "Y" to the column if the final three characters are "IDE" or if the final five characters are "IDE-(and a wildcard)", else it should add a "N".

Even when the location is MyLocation IDE-1, the formula I have is still returning a "N," and I'm not sure what I'm doing wrong.

=IF(OR(RIGHT(L1,3)="IDE", RIGHT(L1,5)="IDE-"&"*"),"Y","N")

Answer 1

3

Try:

The formula in B1:

=IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N")

Or, a little less verbose:

=IF(SUM(COUNTIF(A1,"* IDE"&{"","-?"})),"Y","N")