公式可以写成=IF(AND(B1-C1>10,B1-C1<20),"优秀","其他")或=IF((B1-C1>10)*(B1-C1<20),"优秀","其他") =IF((B1>C1+10)*(B1
=if(and(b1-c1>10,b1-c1<20),"优秀",)区间的这种使用and函数。
a1=if(and(b1-c1>10,b1-c1<20),"优秀","不优秀")
=IF(AND(b1-c1<20,(b1-c1>10),"优秀","其它")