This formula presumes that you have a cell named weight and that weight is
not 0, and that any weight over 400 kilos is £ 40. You can make it more
elaborate. For a few more weights, you could do a table lookup.

=IF(weight<=300,30,IF(weight<=400,35,40))

"kinsey" wrote in message
...
I am trying to create a calculation for haulage/trucking charges

1-300 kilos £ 30
300-400 kilos £ 35
400-500 kilos £ 40

What formula could I use to accomplish this??





--
kinsey