Help to change a formula please (Excel 2003 SP3)

Topic

New Reply

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.

PS: does anybody know why it is saying “You can make 48 more posts until 2010-01-26 20:26” above my messages, am I being expelled after that?

Reply | Quote

Replies

PS: does anybody know why it is saying “You can make 48 more posts until 2010-01-26 20:26” above my messages, am I being expelled after that?

See this thread – including this reply. (Hope you don’t mind the copying our your text.)

Reply | Quote

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.

PS: does anybody know why it is saying “You can make 48 more posts until 2010-01-26 20:26” above my messages, am I being expelled after that?

Hi all

I think that the problem has been solved on another lounge and I am just testing now

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

Reply | Quote