I have been working on this problem for quite a while. I assist with the billing for my company. For certain products that we produce, the state that receives the product charges us tax. Our customers agree to pay the tax. We also charge them for fuel.
I am attempting to create a reverse calculator in excel that will take the total charged and break down the two other values. Both values are percentages. The last piece of information is that the fuel percentage and tax percentage changes by state, city, and sometimes even county. So in this calculator, i must have the ability to change the variables. Below is an example.
Base rate $1,000
Tax 7%
Fuel 26.5%
Total from above is $1,353.55
The total is calculated as follows. $1,353.55=(((1000*0.07)+1000)*0.265)+(1000*0.07)+1000
I am attempting to create a reverse calculator in excel that will take the total charged and break down the two other values. Both values are percentages. The last piece of information is that the fuel percentage and tax percentage changes by state, city, and sometimes even county. So in this calculator, i must have the ability to change the variables. Below is an example.
Base rate $1,000
Tax 7%
Fuel 26.5%
Total from above is $1,353.55
The total is calculated as follows. $1,353.55=(((1000*0.07)+1000)*0.265)+(1000*0.07)+1000