+ Reply to Thread
Results 1 to 4 of 4

Can anyone tell me whats wrong with my code?

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    337

    Can anyone tell me whats wrong with my code?

    basically, its veri simple, if Code start with W and end with 9, result show ABC, if not, if Cu end with W1, result show XYZ, if not result show XXX.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    12,501

    Re: Can anyone tell me whats wrong with my code?

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    337

    Re: Can anyone tell me whats wrong with my code?

    Quote Originally Posted by jindon View Post
    Please Login or Register  to view this content.
    Thanks will try it out. Just curious, if i wan to add a OR after the IF, is it
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    12,501

    Re: Can anyone tell me whats wrong with my code?

    Correct and could be also like
    Please Login or Register  to view this content.

+ 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