1. ## 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. ## 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. ## 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
•