Excel条件格式嵌套公式?答:=IF(AND(A1="tier1",OR(B1="offered",B1="sourcing&interiview")),1,"")*C1<45 =IF(AND(A1="tier1",OR(B1="offered",B1="sourcing&interiview")),1,"")*C1<=60 =IF(AND(A1="tier1",OR(B1="offered",B1="sourcing&interiview")),1,"")*C1>60 =IF(AND(A1="tier2",OR...