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