数据改變 依規定 (9160)

C1=LOOKUP(A1,{-999,-10,-8,-5,-3,-1,1},{20,10,8,4,2,1,0})

另解=LOOKUP(-A1-1%,{-999,0,1,3,5,8,10;0,1,2,4,8,10,20})