[Power=1]<p>必做题:1、=SUBSTITUTE(SUBSTITUTE(B4,"A", ),"B",)下拉</p><p>2、=MID(B12,ROUNDUP(LEN(B12)/2,),IF(MOD(LEN(B12),2)=0,2,1))下拉</p><p>3、=(MOD(MID(B21,15,3),2)=1)*5+55+YEAR(TEXT(TEXT(MID(B21,7,(LEN(B21)=18)*2+6),"00-00-00"),"yyyy-mm-dd"))下拉</p><p>4、=REPT("*",10-LENB(B27))&B27下拉</p><p>5、=8&(MOD(RIGHT(LEFT(B37,2),1),2)=0)*5+3&RIGHT(B37,6)下拉</p><p>6、=IF(SUM((C51={"高级技师","中级技师"})*1),D51*0.4,D51*0.2)下拉</p><p>选做题:=TEXT(B4,"[>90]优秀;[<60]不及格;;")下拉</p><p><font color="#ee1111">全对!</font></p><p><font color="#ee1111">——dgxsdr</font></p>[/Power]
[此贴子已经被dgxsdr于2010-6-20 20:08:06编辑过] |