if the weight is in cel A1 you could try
=IF(A1300,IF(AND(A1300,A1<400),35,40),30)
you will need to change it slightly as you have 2 values for 300 & 400
kilo's. You might also want some validation to prevent the cell having a
value over 500 kilo's
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


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





--
kinsey