assuming that you mean:

1-299
300-399
400-

then try:

=LOOKUP(A1,{0,300,400},{30,35,40})

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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