Formula Negation
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),M ID(T10,6,2)-$H$7),"dd",IF(BE10="t","dn",IF(BF10="t","up",IF(AK 10<"","ck","")))),IF(BE10="t","dn",IF(BF10="t","u p",IF(AK10<"","ck",""))))
HTH
JG
"nastech" wrote:
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(A K10<"","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)),
"CLR" wrote:
=IF(LEFT(T9,1)=":",DoYourFormula,"")
Vaya con Dios,
Chuck, CABGx3
"nastech" wrote in message
...
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
|