Wildcards in a nested IF
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Wildcards in a nested IF

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Here is the formula:
    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(X2="*",X2,IF
    (X2<>"*",B2)))) I don't have the 3rd claus written correctly, as
    there is data (text) in X2 but the formula is returning cell B2
    contents. Suggestions? Column X has many different "comments" so I
    need to use the wildcard. Thanks in advance, this one has me
    stumpted. Ron

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,785
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-02-25 13:24, KellisR wrote:
    Here is the formula:
    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(X2="*",X2,IF
    (X2<>"*",B2)))) I don't have the 3rd claus written correctly, as
    there is data (text) in X2 but the formula is returning cell B2
    contents. Suggestions? Column X has many different "comments" so I
    need to use the wildcard. Thanks in advance, this one has me
    stumpted. Ron
    Ron,

    Try:

    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2),X2,B2)))

    Aladin

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin, I tried to reply that it did not work, but I think I found the reason...

    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2)>0,X2,B2)))

    rather then

    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2),X2,B2)))

    Thanks for pointing me in the right direction.


  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,785
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-02-26 14:14, KellisR wrote:
    Aladin, I tried to reply that it did not work, but I think I found the reason...

    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2)>0,X2,B2)))

    rather then

    =IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2),X2,B2)))

    Thanks for pointing me in the right direction.

    Ron: They should behave alike...

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin

    Many times i see you add +0 or +1 on the end of complex formula and it makes all the difference, why does +0 make the formula work and without if fails.. puzzle me for many months.

    Like multpy by + to get text to value works fine but ODD!


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

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
  •  

 

 
DMCA.com