Perhaps:

=6%*IF(N(E3)<50,0,IF(N(E3)<1000,N(H6),949.99)

(note I've assumed >=1000 warrants use of 949.99 - the tiers outlined do not overlap otherwise)