excel如何判定数字的大中小
发布网友
发布时间:2022-05-03 11:48
我来回答
共5个回答
热心网友
时间:2022-06-19 16:24
你好,在B1输入公式:
如果50算“小”,100算“中”的话:
=IF(A1<=50,"小",IF(A1<=100,"中","大"))
如果50算"中",100算"大"的话
=IF(A1<50,"小",IF(A1<100,"中","大"))
希望可以帮助你
热心网友
时间:2022-06-19 16:24
如果你说的A项是指在表格的A列
则B1单元格写入公式,如果50算小,100算中,则公式如下
=IF(A1<1,"",IF(A1<51,"小",IF(A1<101,"中","大")))
或
=IF(A1<1,,"",LOOKUP(A1,{1,"小";51,"中";101,"大"}))
下拉复制公式
如果50算中,100算大,则公式如下
=IF(A1<1,"",IF(A1<50,"小",IF(A1<100,"中","大")))
或
=IF(A1<1,"",LOOKUP(A1,{1,"小";50,"中";100,"大"}))
下拉复制公式
热心网友
时间:2022-06-19 16:24
在B1输入公式,B1=IF(A1<=50,"小",IF(A1<=100,"中","大")),公式向下填充即可。
热心网友
时间:2022-06-19 16:25
在b2输入:
=if(a2>=1,if(a2>=51,if(a2>=101,if(a2>=151,"","大"),"中"),"小"),"")当不符合条件是,返回空值。
热心网友
时间:2022-06-19 16:26
在B1列中输入公式=IF(A1<=50,"小",IF(AND(A1>50,A1<=100),"中","大")) 然后下拉公式 就OK啦