Calculating Courier Costs

Try this:

=MAX(6.25,SUMPRODUCT(--(D6>{0,20,100}),--(D6-{0,20,100}),{0.3125,-0.0325,0.07}))

see cells (in sheet) shaded purple for derivation of the bits in red (above)