F2公式下拉：
=if(e2<180,"6-",if(e2<=540,"6-18","18+"))
=VLOOKUP(E2,{0,"6-";180,"6-18";540.0001,"18+"},2,1)试试这个
IF函数：=IF(E2<=180,"6-",IF(E2>540,"18+","6-18"))
=if(E2<180,"6-",if(e2>540,"18+","6-18"))
=LOOKUP(E2,{0,180,540},{"6-","6-18","18+"})
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024