T
teratak
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?
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?