+ Reply to Thread
Results 1 to 3 of 3

digit 1 mean extra digit 2 mean normal

  1. #1
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119

    digit 1 mean extra digit 2 mean normal

    HI, I need the function formula something where:
    If Value in A1 as "002-2-12341-8 " ,B1 change to "2" and C1 show "NORMAL"

    If Value in A1 as 212-1-45342-9 ,B1 change to "1" and C1 show "EXTRA"


    NOTE: THE NUMBER MAY BE ANOTHER NUMBER
    THE DIGIT 1 MEAN EXTRA
    THE DIGIT 2 MEAN NORMAL
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464
    Quote Originally Posted by pichai
    HI, I need the function formula something where:
    If Value in A1 as "002-2-12341-8 " ,B1 change to "2" and C1 show "NORMAL"

    If Value in A1 as 212-1-45342-9 ,B1 change to "1" and C1 show "EXTRA"


    NOTE: THE NUMBER MAY BE ANOTHER NUMBER
    THE DIGIT 1 MEAN EXTRA
    THE DIGIT 2 MEAN NORMAL
    try

    B1:
    =If(Len(A1)>=5,Mid(A1,5,1)+0,"")

    C1
    =Lookup(B1,{"",1,2;"","Extra","Normal"})

  3. #3
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119
    hi, jindon
    thanks ,it work well

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1