|
Formula Negation
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 |
Formula Negation
=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 |
Formula Negation
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 |
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 |
Formula Negation
Thankyou, !!
"pinmaster" wrote: 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 |
Formula Negation
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 "pinmaster" wrote: 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 |
| All times are GMT +1. The time now is 07:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com