IF statement

C

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
 
T

Tom Hutchins

Maybe something like this (in L1):

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

Hope this helps,

Hutch
 
Top