Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Formula (2002)

    Does anyone know what this formula means, I am a bit confused by it.

    =IF((G$116)<15,0,IF((G$116)<20,0.35*(G$116-15)*Urals_TON_to_BBL,IF((G$116)<25,12.78+0.45*(G$1 16-20)*Urals_TON_to_BBL,29.2+0.65*(G$116-25)*Urals_TON_to_BBL)))

    Greatly Apprecited! Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Formula (2002)

    This formula appears to calculate a tarriff for something with a rate that goes up in stages. Perhaps transport costs.

    Urals_TON_to_BBL is presumably a defined name that contains the conversion factor from metric tons to barrels. All results are multiplied with this conversion factor.
    Cell G116 contains the number of tons.

    The first 15 tons are free.
    For an amount between 15 and 20 tons, the rate is 0.35 for each ton over 15.
    For an amount between 20 and 25 tons, there is a start rate of 12.78, plus 0.45 for each ton over 20.
    For an amount over 25 tons, there is a staet rate of 29.2, plus 0.65 for each ton over 25.

  3. #3
    New Lounger
    Join Date
    Jul 2008
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formula (2002)

    Thanks Hans!

    The starting rate is actually the amount taxed under the previous bracket, so if you are already in the 20 - 25 range then you must also consider the amount taxed at .35 which is 20 - 15 = 5, so 5 * .35 * 7.3(Conversion factor)

    Thanks for the help!

    Best,
    Igor

Posting Permissions

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