www.fltk.net > ExCEl中,A列如果大于0小于等于5,那么B列是19,如果A列大于5,小于等于10,那么B列是2

ExCEl中,A列如果大于0小于等于5,那么B列是19,如果A列大于5,小于等于10,那么B列是2

=if(and(A1>0,A1<=5),19,if(and(A1>5,A1<

使用if嵌套语句,公式如下: =if(B2>=10, 1, if(5<B2<10,

if(A1>60,300,if(A1>=17,A1*5,""))

在D2里写公式=IF(C2>0.5,A2,B2),然后向下填充。

=IF(AND(A2>=0,A2<=5),"是","否&q

1、可以采用嵌套if函数,较为麻烦。 =IF(A1<10,1,IF(A1<20,2

=IF(A1<=500,5,IF(A1<=2000,10,IF(A1<=5000,

只能分别在bc输入公式 b1=if(a1>=0,a1,"") c1=i

选中l列,点条件格式,新建规则,条件设置为=Ⅰ1<=G1,点格式设置需要的颜色。

=if(A1>=5,"大",if(A1<=2,"小&quo

网站地图

All rights reserved Powered by www.fltk.net

copyright ©right 2010-2021。
www.fltk.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com