You can use SUMPRODUCT for this

=SUMPRODUCT(--(sales>{0,100000,300000}),sales-{0,100000,300000},{0.02,0.01,0.01})

where sales is your sales amount - be it cell reference (to value) or constant.

(output of the above based on your values would be 14,319.47)