=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5
来源：学生作业帮助网 编辑：六六作业网 时间：2024/11/25 08:20:59
=IF(Y5="","",IF(AC5>100%,SUMIF($AP$5:$AP$19,X5,$AW$5:$AW$19),IF(AND(AC5>=90%,AC5=IF(Y5="","",IF(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="","",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