|
函入6期班1组012号交作业
<p>交作业<strong><font color="#ff3300" size="4">函入6期班1组012号交作业</font></strong></p><p><strong><font color="#ff3300" size="4">1.=IF($B23<1,$C$7,IF($B23<3,$C$8,IF($B23<10,$C$9,IF($B23<15,$C$10,IF($B23<20,$C$11,IF($B23<30,$C$12,IF($B23<40,$C$13,IF($B23<50,$C$14,""))))))))&IF(($B23<60)*($B23>=50),$C$15,IF(($B23<70)*($B23>=60),$C$16,IF(($B23<80)*($B23>=70),$C$17,IF(($B23<90)*($B23>=80),$C$18,IF(($B23<100)*($B23>=90),$C$19,IF($B23=100,$C$20,""))))))</font></strong></p><p><strong><font color="#ff3300" size="4">2.=IF(INFO("release")="11.0",$B$7,IF(INFO("release")="14.0",$B$9,IF(INFO("release")="12.0",$B$8)))</font></strong></p><p><strong><font color="#ff3300" size="4">3.=IF(CELL("ADDRESS",D16)=CELL("ADDRESS"),INDEX({"纵向","横向","交叉"},3*RAND()+1),"")</font></strong></p>
EMhBj0jS.rar
(77.63 KB, 下载次数: 3)
|
|