return value based on another value

[Steve]

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

 

[T. Valko]

One way:

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

 

[Jacob Skaria]

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

 

[Steve]

Hi
Works great Thanks.

 

[T. Valko]

You're welcome. Thanks for the feedback!