费率可更改 E2=SUMPRODUCT(TEXT(C2-{0;100;500;2000;5000},"0.0000;!0")*(B$2:B$6-N(+B$1:B$5))/1000)*10000
另解=SUM(TEXT(C2%-{0,1,5,20,50},"[<]!0")*-{-3.15,0.9,1.35,0.45,0.36})*10^3
另解=SUM(TEXT(C2-{0,100,500,2000,5000},"0.0000;!0")*{3.15,-0.9,-1.35,-0.45,-0.36}/1000)*10000
费率可更改=SUMPRODUCT(TEXT(C2/1%%-{0;100;500;2000;5000}/1%%,"0;!0")*(B$2:B$6-N(+B$1:B$5))/1000)
留言
張貼留言