=IF(A1<6,"优秀",IF(A1<11,"良好",IF(A1<=15,"一般")))
=CHOOSE(MATCH(1,FREQUENCY(A1,{5,10}),),"优秀","良好","一般")
B1公式下拉
