|
第一题 =IF((ROW()-3)>=(COLUMN()-1),(ROW()-3)&"×"&(COLUMN()-1)&"="&(ROW()-3)*(COLUMN()-1),"")
=IF((ROW()-3)<(COLUMN()-1),"",(ROW()-3)&"×"&(COLUMN()-1)&"="&(ROW()-3)*(COLUMN()-1))
第二题 =IF(SUBTOTAL(1,C32:E32)<60,"不及格",IF(SUBTOTAL(1,C32:E32)<85,"及格","优秀"))
=IF(AVERAGE(C32:E32)<60,"不及格",IF(AVERAGE(C32:E32)<85,"及格","优秀"))
第三题 =IF(OR(D50="高级技师",D50="中级技师"),E50*40%,E50*20%)
=IF(NOT(OR(D50="高级技师",D50="中级技师")),E50*20%,E50*40%)
第四题 =REPLACE(CELL("filename"),1,LEN(LEFT(CELL("filename"),FIND("]",CELL("filename")))),"")
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
选做题 =LEN(B4)*2-LENB(B4)
|
|