Len Left If formula

[Jack in the UK]

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

 

[Steve Hartman]

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

 

[Derek]

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

 

[Aladin Akyurek]

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

 

[Jack in the UK]

Cheers guys, im some ideas to work on,

Speak soon

Jack

 

[IML]

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