software

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

=IF(LEFT(T9,1)=quot;:quot;,DoYourFormula,quot;quot;)

Vaya con Dios,
Chuck, CABGx3quot;nastechquot; gt; wrote in message
...
gt; How do I skip a formula, if left of cell does not equal a colon, followed
by
gt; 7 numbers? thanks.
gt;
gt; e.g.: date yymmdd
gt; :060120
gt;
gt; e.g.:
gt; IF(LEFT(T9,7)= ??(:0000000),then do formula
thanks, already using that (but can use help with following formula)

=IF(LEFT(T10,1)=quot;:quot;,IF(AND(TODAY()gt;DATE(MID(T10,2, 2) 100,MID(T10,4,2),MID(T10,6,2)-$H$7)),quot;ddquot;,IF(BE10=quot;Tquot;,quot;dnquot;,IF(BF10=quot;Tquot;,quot;upquot;,IF(A K10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))))

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

quot;CLRquot; wrote:

gt; =IF(LEFT(T9,1)=quot;:quot;,DoYourFormula,quot;quot;)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; How do I skip a formula, if left of cell does not equal a colon, followed
gt; by
gt; gt; 7 numbers? thanks.
gt; gt;
gt; gt; e.g.: date yymmdd
gt; gt; :060120
gt; gt;
gt; gt; e.g.:
gt; gt; IF(LEFT(T9,7)= ??(:0000000),then do formula
gt;
gt;
gt;

Try this:

=IF(AND(LEFT(T10,1)=quot;:quot;,ISNUMBER(ABS(MID(T10,2,6)) )),IF(TODAY()gt;DATE(MID(T10,2,2) 100,MID(T10,4,2),M ID(T10,6,2)-$H$7),quot;ddquot;,IF(BE10=quot;tquot;,quot;dnquot;,IF(BF10=quot;tquot;,quot;upquot;,IF(AK 10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))),IF(BE10=quot;tquot;,quot;dnquot;,IF(BF10=quot;tquot;,quot;u pquot;,IF(AK10lt;gt;quot;quot;,quot;ckquot;,quot;quot;))))

HTH
JG

quot;nastechquot; wrote:

gt; thanks, already using that (but can use help with following formula)
gt;
gt; =IF(LEFT(T10,1)=quot;:quot;,IF(AND(TODAY()gt;DATE(MID(T10,2, 2) 100,MID(T10,4,2),MID(T10,6,2)-$H$7)),quot;ddquot;,IF(BE10=quot;Tquot;,quot;dnquot;,IF(BF10=quot;Tquot;,quot;upquot;,IF(A K10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))))
gt;
gt; works if: less than today, greater than to day, does not work if no date is
gt; present.
gt; sticks on false, and does not let rest of formula work
gt; currently working on something like:
gt;
gt; IF(ISNUMBER(MID((T10,2,6)),
gt;
gt;
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; =IF(LEFT(T9,1)=quot;:quot;,DoYourFormula,quot;quot;)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;nastechquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; How do I skip a formula, if left of cell does not equal a colon, followed
gt; gt; by
gt; gt; gt; 7 numbers? thanks.
gt; gt; gt;
gt; gt; gt; e.g.: date yymmdd
gt; gt; gt; :060120
gt; gt; gt;
gt; gt; gt; e.g.:
gt; gt; gt; IF(LEFT(T9,7)= ??(:0000000),then do formula
gt; gt;
gt; gt;
gt; gt;

Thankyou, !!

quot;pinmasterquot; wrote:

gt; Try this:
gt;
gt; =IF(AND(LEFT(T10,1)=quot;:quot;,ISNUMBER(ABS(MID(T10,2,6)) )),IF(TODAY()gt;DATE(MID(T10,2,2) 100,MID(T10,4,2),M ID(T10,6,2)-$H$7),quot;ddquot;,IF(BE10=quot;tquot;,quot;dnquot;,IF(BF10=quot;tquot;,quot;upquot;,IF(AK 10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))),IF(BE10=quot;tquot;,quot;dnquot;,IF(BF10=quot;tquot;,quot;u pquot;,IF(AK10lt;gt;quot;quot;,quot;ckquot;,quot;quot;))))
gt;
gt; HTH
gt; JG
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; thanks, already using that (but can use help with following formula)
gt; gt;
gt; gt; =IF(LEFT(T10,1)=quot;:quot;,IF(AND(TODAY()gt;DATE(MID(T10,2, 2) 100,MID(T10,4,2),MID(T10,6,2)-$H$7)),quot;ddquot;,IF(BE10=quot;Tquot;,quot;dnquot;,IF(BF10=quot;Tquot;,quot;upquot;,IF(A K10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))))
gt; gt;
gt; gt; works if: less than today, greater than to day, does not work if no date is
gt; gt; present.
gt; gt; sticks on false, and does not let rest of formula work
gt; gt; currently working on something like:
gt; gt;
gt; gt; IF(ISNUMBER(MID((T10,2,6)),
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; =IF(LEFT(T9,1)=quot;:quot;,DoYourFormula,quot;quot;)
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;nastechquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; How do I skip a formula, if left of cell does not equal a colon, followed
gt; gt; gt; by
gt; gt; gt; gt; 7 numbers? thanks.
gt; gt; gt; gt;
gt; gt; gt; gt; e.g.: date yymmdd
gt; gt; gt; gt; :060120
gt; gt; gt; gt;
gt; gt; gt; gt; e.g.:
gt; gt; gt; gt; IF(LEFT(T9,7)= ??(:0000000),then do formula
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

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

quot;pinmasterquot; wrote:

gt; Try this:
gt;
gt; =IF(AND(LEFT(T10,1)=quot;:quot;,ISNUMBER(ABS(MID(T10,2,6)) )),IF(TODAY()gt;DATE(MID(T10,2,2) 100,MID(T10,4,2),M ID(T10,6,2)-$H$7),quot;ddquot;,IF(BE10=quot;tquot;,quot;dnquot;,IF(BF10=quot;tquot;,quot;upquot;,IF(AK 10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))),IF(BE10=quot;tquot;,quot;dnquot;,IF(BF10=quot;tquot;,quot;u pquot;,IF(AK10lt;gt;quot;quot;,quot;ckquot;,quot;quot;))))
gt;
gt; HTH
gt; JG
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; thanks, already using that (but can use help with following formula)
gt; gt;
gt; gt; =IF(LEFT(T10,1)=quot;:quot;,IF(AND(TODAY()gt;DATE(MID(T10,2, 2) 100,MID(T10,4,2),MID(T10,6,2)-$H$7)),quot;ddquot;,IF(BE10=quot;Tquot;,quot;dnquot;,IF(BF10=quot;Tquot;,quot;upquot;,IF(A K10lt;gt;quot;quot;,quot;ckquot;,quot;quot;)))))
gt; gt;
gt; gt; works if: less than today, greater than to day, does not work if no date is
gt; gt; present.
gt; gt; sticks on false, and does not let rest of formula work
gt; gt; currently working on something like:
gt; gt;
gt; gt; IF(ISNUMBER(MID((T10,2,6)),
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; =IF(LEFT(T9,1)=quot;:quot;,DoYourFormula,quot;quot;)
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;nastechquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; How do I skip a formula, if left of cell does not equal a colon, followed
gt; gt; gt; by
gt; gt; gt; gt; 7 numbers? thanks.
gt; gt; gt; gt;
gt; gt; gt; gt; e.g.: date yymmdd
gt; gt; gt; gt; :060120
gt; gt; gt; gt;
gt; gt; gt; gt; e.g.:
gt; gt; gt; gt; IF(LEFT(T9,7)= ??(:0000000),then do formula
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;