唯壹 发表于 2021-12-25 09:07:35

=IF(AND(OR(B2="A",B2="B",B2="E"),OR(MID(A2,5,2)="68",MID(A2,5,2)="6F")),"高级","低级")

均富尚未成功 发表于 2021-12-26 17:31:17

=IF(OR(B2={"A","B","E"})*OR(RIGHT(A2,2)={"68","6F"}),"高级","低级")
下拉

袁平 发表于 2021-12-30 23:44:47

=IF(OR(RIGHT(A2&B2,3)=({"68","6F"}&{"A";"B";"E"})),"高级","低级")

宁静盛出 发表于 2022-1-16 14:11:22

=IF(SUMPRODUCT((B2={"A","B","E"})*(RIGHT(A2,2)={"68";"6F"})),"高","低")&"级"

暖评君 发表于 2022-1-19 09:10:40

其实楼主可以依据上一题的公式答案，作相应的变更就好了，既能解决问题，又能学到东西

月亮星星 发表于 2022-1-20 13:53:38

=MID("低高",OR(MID(A2,5,2)={"68","6F"})*OR(B2={"A","B","E"})+1,1)&"级"

片岩 发表于 2022-1-27 03:38:19

厉害厉害,学习学习
页: 1 2 [3]
查看完整版本: 求助