=LOOKUP(B2/10^6,{0,3,8,15,30},{6,7,8,9,10}/10^4)
復制並下拉,即可得到提成比例。
提成額公式為:
=B2*LOOKUP(B2/1000000,{0,3,8,15,30},{6,7,8,9,10}/10000)