=IF(B1<=5,"小",IF(AND(B1>=6,B1<=10),"中",IF(AND(B1>=11,B1<=15),"大","空")))
OK,搞定，有问题请追加，无问题，请采纳；
你少写了OR函数
=IF(OR(F15={1,2,3,4,5}),"小",IF(OR(F15={6,7,8,9,10}),"中",IF(OR(F15={11,12,13,14,15}),"大","不合格")))
公式也可以写成
=IF((F15<1)+(F15>15),"不合格",LOOKUP(F15,{1,"小";6,"中";11,"大"}))
=IF((B15<1)+(B15>16),"不合格",LOOKUP(B15,{1,6,11},{"小","中","大"}))
疑问：你对B列数据做判断，干吗会引用到F15？
=IF(A1<6,"小",IF(A1<11,"中",IF(A1<16,"大","不合格")))
你输入如下公式试试看：
=IF(OR(B2<1,B2>15),"不合格",IF(B2<=5,"小",IF(B2<=10,"中","大")))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024