=IF(RIGHT(A1,3)="(L)","Local","no")


"KrispyData" wrote:

I want to create a formula that states: if cell in columnA ends in (L) then
show result in ColumnB as Local.

sample data:
ColumnA
1.Wow Widget Store (L)
2.Widgets N More
3.Major Widget Store (L)
4.Allstar Widgets

I tried using the following formula:
if(A1="*(L)","Local","no)
Excel will not accept that. Any suggestions?