One way:

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

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
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