40,"超大件")下拉。-" />

wpsif判断一个格子的数大于等于5且小于等于10返回值为小件,5

柒家逗比龙龙 |浏览1114次
收藏|2021/06/27 21:22

满意回答

2021/06/27 21:45

C2公式 =IFS(A2<5,"",A2<=11,"小件",A2<=21,"中件",A2<=31,"大件",A2<=40,"国标",A2>40,"超大件")下拉。

寂园晓月

其他回答(1)
  • =IF(A1<=10,"小件",IF(A1<=20,"中件",IF(A1<=30,"大件","国标")))
    回答于 2021/06/27 22:10
0人关注该问题
+1

 加载中...