| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a few condition
hi,
I am using excel 2003. I am trying to formulate a transportation cost base on weight with a few condition. If the total weight is equal or less than 500g the cost is $5 If the total weight is equal or less than 750g the cost is $6 If the total weight is equal or less than 1000g the cost is $8 If the total weight is equal or less than 1250g the cost is $9 If the total weight is equal or less than 1500g the cost is $10 If the total weight is equal or less than 1750g the cost is $11 If the total weight is equal or less than 2000g the cost is $12 How do I set the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if condition | Excel Discussion (Misc queries) | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
| Condition IF | Excel Discussion (Misc queries) | |||
Threaded Mode
