wpsif判断一个格子的数大于等于5且小于等于10返回值为小件,
if判断一个格子的数大于等于5且小于等于10返回值为小件,大于等于11且小于等于20返回值为中件,大于等于21且小于等于30返回值为大件,大于等于31且小于等于40返回值为国标,
C2公式 =IFS(A2<5,"",A2<=11,"小件",A2<=21,"中件",A2<=31,"大件",A2<=40,"国标",A2>40,"超大件")
下拉。
=IF(A1<=10,"小件",IF(A1<=20,"中件",IF(A1<=30,"大件","国标")))
热门标签: