IF statement

  • Thread starter Thread starter confused
  • Start date Start date
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
 
Maybe something like this (in L1):

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

Hope this helps,

Hutch
 
Back
Top