=10,=20,=30,还有>30的归在哪里?
设a在a1单元格,在b1输入:=if(a1="","",int(a1/10)*5+10)
=if(A1<10,10,if(A1<20,15,if(A1<30,20,"")))
结果返回在E列,则:E2=IF(A2>20,30,IF(A2>10,15,10))