區間數字 取代號 (15025)

C2=TEXT(B2,"[<4]上;[<8]中;下")

C2另解=TEXT(B2,"[>7]下;[>3]中;上")

C2另解=LOOKUP(B2,{1,4,8},{"上","中","下"})

用表列 D2=VLOOKUP(B2,H:I,2)