| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
return value based on another value
Hi
Works great Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a Title based on a name | Excel Worksheet Functions | |||
| Return a value based on another cell | Excel Discussion (Misc queries) | |||
| return value based on two criteria | Excel Worksheet Functions | |||
| return value based upon another | Excel Worksheet Functions | |||
| I want to return "0" based on another cell | Excel Worksheet Functions | |||
Linear Mode
