if(and(A1>=60,A1<80),"10",if(and(A1>=80,A1<100),"12",if(and(A1>=100,A1<120),"14",if(and(A1>=120,A1<140),"16",if(and(A1>=140,A1<160),"18",if(and(A1>=160,A1<180),"20",if(and(A1>=180,A1<200),"22",if(and(A1>=200,A1<220),"24",if(and(A1>=220,A1<240),"26",if(and(A1>=240,A1<260),"28",if(and(A1>=260,A1<500),"30",if(and(A1<60,"10"))))))))))))
谢谢,A1少于60的时候没有为10
追答=VLOOKUP(A1,{0,10;80,12;100,14;120,16;140,18;160,20;180,22;200,24;220,26;240,28;260,30},2)
就是个多区间的判断吧,这个用lookup就可以了,公式看附件