IF statement

[confused]

Is there a way to write an if statement to look at column b and have it
check column L with a YES if the name starts with OD?

thank you

 

[Tom Hutchins]

Maybe something like this (in L1):

=IF(LEFT(B1,2)="OD","YES","NO")

Hope this helps,

Hutch