<p>[Power=1]1、=SUBSTITUTE(SUBSTITUTE(B4,"A",),"B",)<br/><br/>2、=IF(MOD(LEN(B12),2),MID(B12,LEN(B12)/2+1,1),MID(B12,LEN(B12)/2,2))<br/><br/>3、=YEAR(TEXT(MID(B21,7,6+(LEN(B21)=18)*2),"#-00-00"))+IF(MOD(MID(<font color="#ff0000">B22</font>,15,3),2),"<font color="#ee1111">55","60</font>") <font color="#dd2222">细看有错!=YEAR(TEXT(MID(B21,7,6+(LEN(B21)=18)*2),"#-00-00"))+IF(MOD(MID(B21,15,3),2),"60","55")<br/></font><br/>4、=REPT("*",10-LENB(B27))&B27<br/><br/>5、=IF(MOD(MID(B37,2,1),2),REPLACE(B37,2,,"3"),REPLACE(B37,2,,"8"))<br/><br/>6、=IF(C51="高级技师",D51*40%,D51*20%) <font color="#f70909">不对</font></p><p><font color="#f70909">继续努力!</font></p><p><font color="#f70909">——dgxsdr</font></p><p>[/Power]</p>
[此贴子已经被dgxsdr于2010-6-14 15:54:36编辑过] |