作业帮=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5
来源：学生作业帮助网 编辑：作业帮 时间：2024/11/05 17:33:08
100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5" />x)tӈ4UR" @U'8Uq P1::*`~8 Vck d$SP;YO76=tZ2Ӟ}6uDcɳik#MXt²';v=_K, @Qg3=_@mh|d]} U! ȔsV8>`h: $@g\OwM)
+
7i gX I=Xk;$(8dǔ8KJÈw6!l`_\gJ V
=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5
=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5
=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5
多层嵌套的if函数
判断Y5是否为空,
是,显示空
否,判断AC5是否大于100%
是,在AP5到AP19内寻找X5,找到的项对应在AW5到AW19数值内进行求和
否,判断AC5是否大于等于90%,并且小于等于100%
是,在AP5到AP19内寻找X5,找到的项对应在AV5到AV19数值内进行求和
否,显示0