请问能简化该公式吗?能简化该公式吗?=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/06 03:45:13

请问能简化该公式吗?能简化该公式吗?=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)