不規則區間評語 (10241)

E2=LOOKUP(D2,{0,"一般";30,"较优";40,"优";100,"较优";200,"一般";500,"较劣";1000,"劣"})

另解=LOOKUP(D2,{0,30,40,100,200,500,1000},{"一般","较优","优","较优","一般","较劣","劣"})