Excel中判断数字大小怎么设置

答案:6 悬赏:20 手机版

解决时间 2021-01-04 07:00

提问者网友：你挡着我发光了
2021-01-03 16:20

比如说 A1是100 A2是80 A3是200 然后在B这一列输出判断结果（假设大于100输出“大”小于100输出“小” 不胜感激
如果是等于100 输出中怎么做呵呵

最佳答案

五星知识达人网友：空山清雨
2021-01-03 16:51

=LOOKUP(A1,{0,100,100.00001},{"小","中","大"})

全部回答

1楼网友：逃夭
2021-01-03 20:11

B1输入 =IF(A1>100,"大","小")

2楼网友：摆渡翁
2021-01-03 19:53

b1=if(a1>100,"大",if(a1<100,"小"))

3楼网友：洎扰庸人
2021-01-03 18:46

b1输入 =text(a1,"[>100]大;[<100]小;这种情况你没说") 向下填充

4楼网友：老鼠爱大米
2021-01-03 18:41

B1=IF(A1>100,"大"，IF(A1<100),"小","我现在等于100怎么办？大人") 然后拉着填充柄向右拉就好了

5楼网友：独钓一江月
2021-01-03 18:20

在d1单元格中输入 =if(a1=max(a1:c1),"大",if(a1=min(a1:c1),"小","中"))&if(b1=max(a1:c1),"大",if(b1=min(a1:c1),"小","中"))&if(c1=max(a1:c1),"大",if(c1=min(a1:c1),"小","中")) 然后将公式向下复制. 可以正确判断呀,但如果a1:c1有空单元格,判断出来的结果可能与你要求的不相符,加上个个函数让其有空单元格时不进行计算就可以了,如下 =if(or(isblank(a1),isblank(b1),isblank(c1)),"",if(a1=max(a1:c1),"大",if(a1=min(a1:c1),"小","中"))&if(b1=max(a1:c1),"大",if(b1=min(a1:c1),"小","中"))&if(c1=max(a1:c1),"大",if(c1=min(a1:c1),"小","中")))

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！