Excel,想判断A1小于等于B1,并向下顺延,在条件格式中怎么操作,或者有没...答:两种方式,第一种,就是A1-B1,用筛选小于0的就是满足你说的条件,第二种用函数公式在C1输入:=IF(A1<B1,0,1),然后你筛选0,就是满足你说的条件 回答补充问题,在C1输入公式=IF(B1-A1=B1,0,IF(A1<B1,2,3)),筛选0为A1=0,2为A1<B1,3为A1>B1 ...
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 六个条件格式,依次填写,...