First I think you have a couple of typos. You can't have two rates for 300 or
400

Maybe you mean

1-300
301-400
401-500

or do you mean?

1-299
300-399
400-500

Will there ever be fractions like 299.96 kg?

Will there ever be more than 500 kg?

If so, would the max be £40

=LOOKUP(A1,{1,301,401,501},{30,35,40,40})

Try the above............adjust ranges as needed.


Gord Dibben MS Excel MVP


On Sat, 29 Sep 2007 13:26:03 -0700, kinsey
wrote:

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