Help with a rates formula please

[steveh]

Cross Post

This post has been posted on another forum already without a resolution yet

Good morning

I need some help please in revamping a formula for a tariff

I was going to try and explain everything here but it got too complicated. I have attached a copy of the workbook which calculates a rate based on a table in the rates and surcharges tab, however my supplier has now simplified the tariff structure to a base rate for 1 kilo and then a rate per half a kilo thereafter so I would only need to reference A4:A5 and B4:F5.

There are about 5 different calculations (highlighted in red) in the calculation tab but I honestly can't remember how it got that complicated.

Steve

[HansV]

Does this formula in E32 do what you want?

=INDEX('Rates + Surcharge'!$J$4:$N$4,C32)+INDEX('Rates + Surcharge'!$J$5:$N$5,C32)*ROUNDUP(2*MAX(D32-1,0),0)

[steveh]

Cheers Hans

Bang on the money

Thanks

Steve