Sorry, didn't pay enough attention. The formula will not work. Your criteria
need clarification.

1-300 kilos is £ 30, 300 - 400 kilos is £ 35. You can't have that. 300 kilos
is both £ 30 and £ 35 and 400 kilos is both £ 35 and £ 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