判斷 奖励 (11161)

C2=LOOKUP(B2,{0,501,901},{0,50,100})

另解=IF(B2>900,100,IF(B2>500,50,0))

另解=50*2^(B2>900)*(B2>500)