return value based on another value
 

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

return value based on another value
 

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

return value based on another value
 

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

return value based on another value
 

Hi
Works great Thanks.

return value based on another value
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Hi
Works great Thanks.