=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/27 14:02:40
![=IF(Y5=](/uploads/image/z/14196812-68-2.jpg?t=%3DIF%28Y5%3D%22%22%2C%22%22%2CIF%28AC5%3E100%25%2CSUMIF%28%24AP%245%3A%24AP%2419%2CX5%2C%24AW%245%3A%24AW%2419%29%2CIF%28AND%28AC5%3E%3D90%25%2CAC5)
x)tӈ4UR" @U'8UqP1::*`~8 Vck d$SP;YO76=tZ2Ӟ}6uDcɳik#MXt²';v=_K, @Qg3=_@mh|d]} U! ȔsV8>`h: $@g\OwM)
+
7igXI=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