Formula Negation

[nastech]

How do I skip a formula, if left of cell does not equal a colon, followed by
7 numbers? thanks.

e.g.: date yymmdd
:060120

e.g.:
IF(LEFT(T9,7)= ??0000000),then do formula

 

[CLR]

=IF(LEFT(T9,1)=":",DoYourFormula,"")

Vaya con Dios,
Chuck, CABGx3

 

[nastech]

thanks, already using that (but can use help with following formula)

=IF(LEFT(T10,1)=":",IF(AND(TODAY()>DATE(MID(T10,2,2)+100,MID(T10,4,2),MID(T10,6,2)-$H$7)),"dd",IF(BE10="T","dn",IF(BF10="T","up",IF(AK10<>"","ck","")))))

works if: less than today, greater than to day, does not work if no date is
present.
sticks on false, and does not let rest of formula work
currently working on something like:

IF(ISNUMBER(MID((T10,2,6)),

 

[pinmaster]

Try this:

=IF(AND(LEFT(T10,1)=":",ISNUMBER(ABS(MID(T10,2,6)))),IF(TODAY()>DATE(MID(T10,2,2)+100,MID(T10,4,2),MID(T10,6,2)-$H$7),"dd",IF(BE10="t","dn",IF(BF10="t","up",IF(AK10<>"","ck","")))),IF(BE10="t","dn",IF(BF10="t","up",IF(AK10<>"","ck",""))))

HTH
JG

 

[nastech]

Thankyou, !!

Try this:

=IF(AND(LEFT(T10,1)=":",ISNUMBER(ABS(MID(T10,2,6)))),IF(TODAY()>DATE(MID(T10,2,2)+100,MID(T10,4,2),MID(T10,6,2)-$H$7),"dd",IF(BE10="t","dn",IF(BF10="t","up",IF(AK10<>"","ck","")))),IF(BE10="t","dn",IF(BF10="t","up",IF(AK10<>"","ck",""))))

HTH
JG

 

[nastech]

follow up to followup, sorry for the 2nd, but didn't say much before, got
info from ~3 or 4 people, that helped alot, thanks