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!
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!