| 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 |
| 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 | |||
Threaded Mode
