Closed Thread
Results 1 to 3 of 3

IF and MID function

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    Singapore
    MS-Off Ver
    Office 2010
    Posts
    11

    IF and MID function

    Hi All,

    Nice to meet you all.
    Can you please provide me a solution that I'm encountering.

    There is a Scan ID 0019-0000-00-000

    I would like to make a condition
    if the last 3 digit ends with xxxx-xxxx-xx-000 then the result will show Customer ID.
    If the last 6 digit ends with xxxx-xxxx-00-000 then the result will show Meter ID.
    If the last 10 digits ends with xxxx-0000-00-000 then the result will show Store ID.

    But I have some difficulties facing the issue.
    First of all I use MID function and IF function.
    Please suggest me how to solve this issue.

    Thanks you for your support.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    3,304

    Re: IF and MID function

    Duplicate thread

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,315

    Re: IF and MID function

    Please read our simple forum rules, in particular, rule #5, and abide by them in the future.

    Thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

Closed 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