本帖最后由 rlzcjrrmy 于 2015-11-26 17:24 编辑
[201502函初]
第一题:- =RANDBETWEEN(1000,2000)&TEXT(RANDBETWEEN(1,12),"00")&TEXT(RANDBETWEEN(1,31),"00")&TEXT(RANDBETWEEN(1,24),"00")&TEXT(RANDBETWEEN(1,60),"00"&TEXT(RANDBETWEEN(1,60),"00"))&TEXT(RANDBETWEEN(1,100),"000")
复制代码 第二题:- =IF(IFERROR(FIND("/",IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),""))),IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),"")))<100,"",IFERROR(FIND("/",IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),""))),IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),""))))
复制代码 第三题:- =IF(AND(RANK(A16,$A$16:$A$34)>1,RANK(A16,$A$16:$A$34)<10),"",RANK(A16,$A$16:$A$34))
复制代码 |