如果A2=倚天剑1或者倚天剑2,B2>=10000或者A2=屠龙刀1或者屠龙刀2,B2>=50000在C2显示 上品,否则为空
公式为(下拉填充):
=IF(OR(AND(OR(A2="倚天剑1",A2="倚天剑2"),B2>=10000),AND(OR(A2="屠龙刀1",A2="屠龙刀2"),B2>=50000)),"上品","")
如图所示:
C2=IF(OR(AND(LEFT(A2,LEN(A2)-1)="倚天剑",B2>=10000),AND(LEFT(A2,LEN(A2)-1)="屠龙刀",B2>=10000)),"上品","")向下复制