【函中201301班】第二讲A组作业上交帖

myszcpf

【函中201301班】-A15-MYSZCPF
第一题：d4单元格输入公式，下拉

1. =IF(B4>200,200,IF(B4>0,B4,0))

复制代码

第二题：d13单元格输入公式，下拉

1. =IF(B13>=300,3,IF(B13>=200,2,IF(B13>=100,1,0)))

复制代码

第三题：d22单元格输入公式，下拉

1. =IF(B22=120,"S",IF(B22>=100,"A",IF(B22>=80,"B",IF(B22>=60,"C","D"))))

复制代码

第四题：d34单元格输入公式，下拉

1. =IF(B34=C34,"TRUE","FALSE")

复制代码

第五题：d46单元格输入公式，下拉

1. =IF(B46<>0,"有","无")

复制代码

第六题：d64单元格输入公式

1. {=IF(SUM((B56:B64>=70)*(B56:B64<=90)),SUM((B56:B64>=70)*(B56:B64<=90)))}

复制代码

第七题：d76单元格输入公式

1. {=IF((B68:B76<60)+(B68:B76>90)>0,COUNTIF(B68:B76,"<60")+COUNTIF(B68:B76,">90"))}

复制代码

清风细雨123

【函中201301班】-A02-清风细雨123
1、=IF(B4>200,200,MAX(B4,0))
2、=IF(B13>=300,3,IF(B13>=200,2,IF(B13>=100,1,0)))
3、=IF(B22=120,"S",IF(B22>=100,"A",IF(B22>=80,"B",IF(B22>=60,"C","D"))))
4、=B34=C34
5、=IF(B46<>0,"有","无")
6、=SUM((IF((B56:B64>70)*(B56:B64<90),1,))) ctrl+shift+enter
7、=SUM(IF((B68:B76<60)+(B68:B76>90),1))  ctrl+shift+enter

芒果冰激凌

作业1

1. =IF(B4>0,IF(B4<200,B4,200),)

复制代码

作业2

1. =INT(B13/100)

复制代码

作业3

1. =LOOKUP(B22,{0,60,80,100,120},{"D","C","B","A","S"})

复制代码

作业4

1. =B34=C34

复制代码

作业5

1. =IF(B46,"有","无")

复制代码

作业6

1. =SUMPRODUCT(IF(B56:B64>69,1)*(B56:B64<91))

复制代码

作业7

1. =SUM(IF(B68:B76<60,1)+(B68:B76>89))

复制代码

augustzhu1983

【函中201301班】-A08-augustzhu1983
第一题

1. =IF(B4<=0,,IF(B4<200,B4,200))

复制代码

1. =MAX(MIN(B4,200),)

复制代码

第二题

1. =IF(B13%<1,0,IF(B13%<2,1,IF(B13%<3,2,3)))

复制代码

1. =INT(B13%)

复制代码

第三题

1. =IF(B22<60,"D",IF(B22<80,"C",IF(B22<100,"B",IF(B22<120,"A","S"))))

复制代码

1. =MID("DDDCBAS",B22/20+1,1)

复制代码

第四题

1. =IF(B34=C34,1=1)

复制代码

第五题

1. =IF(B46,"有","无")

复制代码

第六题

1. =SUM(IF((B56:B64>=70)*(B56:B64<=90),1))

复制代码

1. =SUM((B56:B64>70)*(B56:B64<90))

复制代码

第七题

1. =SUM(IF((B68:B76>90)+(B68:B76<60),1))

复制代码

1. =SUM((B68:B76>90)+(B68:B76<60))

复制代码

xiaox0124

1. =IF(B4<=0,0,IF(B4<200,B4,200))

复制代码

1. =IF(B13<100,0,IF(B13<200,1,IF(B13<300,2,3)))

复制代码

1. =IF(B22>119,"S",IF(B22>99,"A",IF(B22>79,"B",IF(B22>59,"C","D"))))

复制代码

1. =B34=C34

复制代码

1. =IF(B46=0,"无","有")

复制代码

1. =COUNT(B68:B76)-SUMPRODUCT((B68:B76>=60)*(B68:B76<=90))

复制代码

1. =SUMPRODUCT((B56:B64<90)*(B56:B64>70))

复制代码