多个条件不是这样写的，要用and函数。具体的你参考一下
这个还有更简单的写法，自己慢慢摸索。
=IF(F2<679,"非会员",IF(AND(F2>=680,F2<=979),"普通会员",IF(AND(F2>=980,F2<=1379),"高级会员",IF(F2>1380,"VIP会员"))))
可以用lookup vlookup＋数组 没有if条件7层的限制
=IF(F2>1380,"VIP会员",IF(F2>980,"高级会员",IF(F2>680,"普通会员","非会员")))
=if(F2<=979,"非会员",IF(F2<=1379,"高级会员","VIP会员"))
=IF(F2<=679,"非会员",IF(AND(F2>=680,F2<=979),"普通会员",IF(AND(F2>=980,F2<=1379),"高级会员",IF(F2>=1380,"VIP会员"))))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024