Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Negative/ False
How do I skip a formula, if left of cell does not equal a colon, followed by
6 numbers? Thanks. e.g.: date yymmdd =IF(LEFT(T9,1)=":", does not work currently working on / need help with something like: =IF(ISNUMBER(MID((T10,2,6)), =IF(AND(LEFT(T10,1)=":",ISNUMBER(MID(T10,2,6))), not doing this right? :yymmdd followed by word text... or: :060122 text then written... $H$7 has 5 for 5 days, I get correct response for greater than & less than date & rest of formula works, if no date is present, i get a FALSE, and rest of formula does not work. =IF(LEFT(T9,1)=":",IF(AND(TODAY()DATE(MID(T9,2,2) +100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd",IF(BE9="T","dn",IF(BF9="T","up",IF(AK9 <"","ck",""))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shorten a Macro | Excel Discussion (Misc queries) | |||
Inconsistent Macro Behavior | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |