Enter formula in B1
Formula: copy to clipboard
=LOOKUP(A1,{0,500,750,1000},{0,5,7.5,10})
then multiply by *
v A B
1 750 7.5
2 200 0
3 1200 10
4 100 0
5 769 7.5