Formula Negation

N

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
 
N

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)),
 
P

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
 
N

nastech

Thankyou, !!

pinmaster said:
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
Click to expand...
 
N

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
 
Top