How to create an IF statement based on first two characters of a cell

tonguencheek · Apr 27, 2010

Hey everyone - how would I create an IF statement that looks at the first two text characters of a particular cell?

Andrew Poulsom · Apr 27, 2010

Example:

=IF(LEFT(A1,2)="AB","OK","Not OK")

tonguencheek · Apr 27, 2010

Great - thanks!

steve hill · May 17, 2017

Andrew Poulsom said:
Example:

=IF(LEFT(A1,2)="AB","OK","Not OK")

can this be extended I have four returned options based on the first character in column A

thanks
Steve