# Thread: Help to change a formula please (Excel 2003 SP3)

1. 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?

2. Originally Posted by B. Bunter Esq.
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.)

3. Originally Posted by B. Bunter Esq.
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)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•