excel if函数如何表示两个单元格相减后数值小于某个数值,如 10<b1-c1<20, "优秀"

2024-11-27 10:29:44
推荐回答(4个)
回答1:

公式可以写成
=IF(AND(B1-C1>10,B1-C1<20),"优秀","其他")

=IF((B1-C1>10)*(B1-C1<20),"优秀","其他")

=IF((B1>C1+10)*(B1

回答2:

=if(and(b1-c1>10,b1-c1<20),"优秀",)
区间的这种使用and函数。

回答3:

a1=if(and(b1-c1>10,b1-c1<20),"优秀","不优秀")

回答4:

=IF(AND(b1-c1<20,(b1-c1>10),"优秀","其它")