Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

  1. #1
    Board Regular
    Join Date
    Apr 2010
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

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

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

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

    Example:

    =IF(LEFT(A1,2)="AB","OK","Not OK")
    Microsoft MVP - Excel

  3. #3
    Board Regular
    Join Date
    Apr 2010
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Great - thanks!

  4. #4
    Board Regular
    Join Date
    Jul 2006
    Location
    hampshire
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Quote Originally Posted by Andrew Poulsom View Post
    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
    thanks for your time
    steve

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •