| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
