=HLOOKUP(A2,{0,500.5,750.5,1000.5,1250.5,1500.5,17 50.5,2000.5;5,6,8,9,10,11,12,"Invalid"},2)

For weight in cell A2 - You didn't say if you were working with only whole
numbers or what you wanted if the weight exceeded 2000. This formula will
treat 750.4 as less than or equal to 750 and 750.5 as greater. If a weight
exceeds 2000 - the cell will display the text Invalid.

"teratak" wrote:

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?