With order value in A1, try

=LOOKUP(A1,{0,0.1,9.5,20,300},{"",2.9,6.9,7.9,0})

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hi I am trying to auto insert shipping cost.
What I need to do is have a formula look at order value and return postage
rate as follows if total = <9.49 return 2.90 if total = 9.50 but <19.99
return 6.90 if total =20.00 but < 299.99 return 7.90 if total =300
return 0