Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?
    Attached Files Attached Files
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by B. Bunter Esq. View Post
    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.)
    Gre

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by B. Bunter Esq. View Post
    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)
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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