If statment involving a list

[SammiBoi]

hello

I want to make a excel IF statement that check against a range of variable specifically if the last 2 letters of a cell equals to either NE, NW or SE, but I am not sure if there's a way to program this in 1 IF statement rather than 3.

I started with something like this but it didn't work

=if(right(A1,2)=OR("NE","NW","SE"),"area in list","area not in list")

Any idea would be greatly appreciated!

 

[jim may]

Maybe....

=IF(OR(RIGHT(A1,2) = "NE",RIGHT(A1,2)="NW",RIGHT(A1,2) = "SE"),"area in list","area not in list")

 

[Peter_SSs]

An alternative that would allow for a more extended list if needed:

=IF(ISNUMBER(MATCH(RIGHT(A1,2),{"NE","NW","SE"},0)),"area in list","area not in list")

 

[SammiBoi]

Both are great formulas! thank you all!