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

Thread: Len Left If formula

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

    Default

    Hi Guys looking for some ideas onthis one

    B1 = Due 1 March 2002
    Or
    B1 = Not Due

    In A1 = If B1 left = DUE then A1 = Due
    or if B1 Left = Not Due the A1 = Not Due

    Hope thats ok guys..

    cheers for you help in advance ill need to drag this one down a few billion...

    Cheers

    Rdgs

    Free Excel based Web Toolbar available here.

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

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In A1 put =IF(Left(B1,3)="Due","Due","Not Due")

    or if you wanted the Due to stand out:

    =IF(Left(B1,3)="Due","Due","")



    [ This Message was edited by: Steve Hartman on 2002-02-28 06:36 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    How about

    =IF(LEFT(B1,1)="D","Due",IF(LEFT(B1,1)="N","Not Due",""))

    Assumes you don't have anything else in column B starting with D or N

    Regards
    Derek

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,657
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Jack,

    =IF(LEFT(B1,4)="Due ","Due","Not Due")

    where the structure in B is assumed to be:

    "Due" followed by a-space followed by a-date. When that's the case, we get "Due" in A,otherwise "Not Due".

    Aladin

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

    Default

    Cheers guys, im some ideas to work on,

    Speak soon

    Jack
    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
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just one more for true overkill:
    =IF(ISNUMBER(SEARCH("not due",B1)),"not due",IF(ISNUMBER(SEARCH("due",B1)),"due",""))

    may help if you have some sloppy typest (like me) or those who don't follow your suggested format

    [ This Message was edited by: IML on 2002-02-28 07:28 ]

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
  •