Calculating a Surcharge Percentage for every 10 cent increase from base.

I am sure I'm making this harder than it really is but....
The OCC law is: (Using $2.00/Gal as a base price)
"The wrecker fees may be adjusted to allow a 1% increase in fees for every ten-cent increase in fuel cost starting at $2.10/gal."

So...I have it working where I type in the number that corresponds to the number of 10-cent increases over 2.00 and it takes the total fees and times them by that number as a percentage. It works...but I want a more clear set way to do this.
So columnA[FuelBasePrice] columnB[FuelActualPrice] columnC[SurchargePercent]
But I can't find a reference anywhere to calculate the number of times a number goes over 10-cents after a base price.

Maybe I'm wording it wrong, I'm not sure.

Can someone please help me?

Originally Posted by FDibbins

Perhaps something like this will help?

	A	B
2	2.00	0.00
3	2.10	1.00
4	2.20	2.00
5	2.30	3.00
6	2.40	4.00
7	2.50	5.00
8	2.60	6.00
9	2.70	7.00
10	2.80	8.00
11	2.90	9.00
12	3.00	10.00
13	3.10	11.00
14	3.20	12.00
15	3.30	13.00
16	3.40	14.00

B2=(A2-2)/0.1

Well, i don't want to have an extra table added on, but the formula you gave helps alot. I modified it to:
=(([@FuelActualPrice]-2)/0.1)/100

Although on $2.20 it gives a result of 0.00%

Also @shg I'm not sure if I'm "supposed" to but i do round the percentage up so at $2.19/Gal I add 2%

Originally Posted by breakingme10

Well, i don't want to have an extra table added on, but the formula you gave helps alot. I modified it to:
=(([@FuelActualPrice]-2)/0.1)/100

Although on $2.20 it gives a result of 0.00%

Also @shg I'm not sure if I'm "supposed" to but i do round the percentage up so at $2.19/Gal I add 2%

I'm so silly even though i typed my modified version of the formula correctly here, i was going against the base price in the actual spreadshet!

Originally Posted by shg

If that were correct, the law would more likely read "... may be adjusted to allow a 0.1% increase in fees for every one-cent increase in fuel cost starting at $2.10/gal."

For billing complaints they have a number they can call regarding rates and fees lol

I can't do that, but as I said earlier I modified the formula under that first post and it works. So I'm good