要大于等于600并且要小于700,请教excel公式怎样列?
在B2中输入 =IF(AND(A2>=600,A2<700),"要的","") 然后向下复制即可
如此即可:Logical_ (A2>=600,A2=600,A2<700),"A","B")简单不?
也可以在B2中输入如下公式: =LOOKUP(A2,{0.001,600,699.999},{"","要的",""})
答:A={x|-2 a>=1/2……(1) a^2 a^2-2a-3 -1<=a<=3……(2) 求(1)(2)交集,得到:1/2<=a<=3详情>>