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")`
Feb 2 in Others 66 views

## 1 answer to this question.

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")`
• 61,360 points

## How can I verify if a column is only decimal using Power Query M formula?

Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE

## How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

## How to open a new tab or a new window while writing an exam in AI - Onlime Remote Proctored

How to open a new tab or ...READ MORE

+1 vote

## I have worked in IT field for 9+ years, but after 2016, due to my family issues, i cant continue working, now, I am searching job, how can i get job after long gap

Hi, @Saravanan, Let me tell you one thing ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE