【函中201301班】-C13-不信这样不重名
题1
=IF(B4<1,0,IF(B4<200,B4,200))
=--TEXT(B4,"[>199]""200"";[>0]#;""0""")
=IF(B4>199,200,MAX(B4,))
题2
=INT(B13/100)
题3
=IF(B22<60,"D",IF(B22<80,"C",IF(B22<100,"B",IF(B22<120,"A","S"))))
=IF(B22=120,"S",IF(B22>99,"A",IF(B22>79,"B",IF(B22>59,"C","D"))))
题4
=B34=C34
=IF(B34=C34,"TRUE","FALSE")
题5
=TEXT(B46,"有;有;无")
=IF(B46=0,"无","有")
题6
=SUM((B56:B64>69)*(B56:B64<91))
=SUM(IF((B56:B64>69)*(B56:B64<91),1))
=COUNTIF(B56:B64,">69")-COUNTIF(B56:B64,">90")
=SUM(IF({1,0},COUNTIF(B56:B64,{"<91","<70"}), -COUNTIF(B56:B64,{"<91","<70"})))
题7
=SUM((B68:B76<60)+(B68:B76>90))
=SUM((B68:B76<60)+(B68:B76>90))
有劳学委批阅。 |