I'm finding excel formula to find two variables vehicle price and tax.tax is 10% of(veh+serv+sale | Mathematics | Page 1

queen bobcatBOT Dec 19, 2023, 6:33 AM

#

sullen dock Dec 19, 2023, 6:39 AM

#

The second variable is not really independent of the first one. Meaning: the 10% tax scales on the "Vehicle price" variable. So, from your picture it seems the tax applices to Vehicle price + service center + commission.
So if x = vehicle price, then the vehicle price + tax is 1.1*(x + service center + commission). (because you add 10% so 0.1)
Then your formula is 1.1(x + service center + commission) + recycling fee = total price

steady quiver Dec 19, 2023, 11:12 AM

#

#

=(B13-(1.1*(B8+B9)+B10+B11+B12))/1.1
=0.1*(B6+B8+B9)

queen bobcatBOT Dec 19, 2023, 11:14 AM

#

I'm finding excel formula to find twovehicle price and tax.tax is 10% of(veh+serv+sale

#I'm finding excel formula to find two variables vehicle price and tax.tax is 10% of(veh+serv+sale