Thanks:  0
Likes:  0

# Thread: Len Left If formula

1. 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

2. 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. 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. 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. Cheers guys, im some ideas to work on,

Speak soon

Jack

6. 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 ]

## User Tag List

#### Posting Permissions

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