请问能简化该公式吗?能简化该公式吗?=IF(P98="质质质",1,IF(P98="质质合",2,IF(P98="质合质",3,IF(P98="合质质",4,IF(P98="质合合",5,IF(P98="合质合",6,IF(P98="合合质",7,IF(P98="合合合",8,""))))))))

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/19 19:36:23
请问能简化该公式吗?能简化该公式吗?=IF(P98=
x){~^4}iϴ>m]tO ziXZ*زt uPNP1BU!"`A4`h*fȂ03*-t4&HO! w lFRzi:Fh:hhztkZkjMR YhDu,V\g <-^

请问能简化该公式吗?能简化该公式吗?=IF(P98="质质质",1,IF(P98="质质合",2,IF(P98="质合质",3,IF(P98="合质质",4,IF(P98="质合合",5,IF(P98="合质合",6,IF(P98="合合质",7,IF(P98="合合合",8,""))))))))
请问能简化该公式吗?
能简化该公式吗?=IF(P98="质质质",1,IF(P98="质质合",2,IF(P98="质合质",3,IF(P98="合质质",4,IF(P98="质合合",5,IF(P98="合质合",6,IF(P98="合合质",7,IF(P98="合合合",8,""))))))))

请问能简化该公式吗?能简化该公式吗?=IF(P98="质质质",1,IF(P98="质质合",2,IF(P98="质合质",3,IF(P98="合质质",4,IF(P98="质合合",5,IF(P98="合质合",6,IF(P98="合合质",7,IF(P98="合合合",8,""))))))))
=MIN(MAX(SUMPRODUCT((MID(P98,4-ROW($1:$3),1)="合")*ROW($2:$4)),1),8)