Is the cost $5 from 500 to 749g?
If so, set up a table of weights and costs, say in A1:B7. Name this range
Cost.
Where you want to retrieve the ifo, insert the formula
=VLOOKUP(<ref to cell with actual weight,Cost,2,1)
eg =VLOOKUP(G11,Cost,2,1)

and it will give you the cost.
--
Hth

Kassie Kasselman
Change xxx to hotmail


"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?