On my spreadsheet I need my customers to be able to punch in any weight in the ranges below and be given the price. Up until 70.5 kg I have calculated each weight and priced each service offerred. But from 71kg onwards I need to multiply each price accorrding to the weight ranges. Can anyone, who is much clever than I help me here (I need the formula) as my excel knowledge does not reach this far and Im starting to short circuit.
IPHW 71 £13.30 £10.40 £4.05 £3.80 £3.35
IPHW 100 £13.10 £10.25 £4.10 £3.80 £3.35
IPHW 300 £12.05 £9.45 £3.80 £3.50 £3.30
IPHW 500 £11.25 £8.75 £3.50 £3.25 £3.25
IPHW 1000 £10.60 £8.30 £3.35 £3.10 £3.25
Column One: Means type of parcel
Coumn 2: Weight
Column 3 - 7: prices per service
Regards
BOTS123
Bookmarks