I Suck At Math: Decalculating Quebec Sales Tax
| Good [+1]Toggle ReplyLink» El_Presidente replied on Thu Jan 28, 2010 @ 7:46pm |
 Coolness: 299270 | I'm working on this excel sheet.
Let's say a product was sold at 12.00$ what would be the formula to know how much said product cost before taxes were applied (quebec taxes) Any ideas? |
| I'm feeling the president right now.. | |
| Good [+1]Toggle ReplyLink» Holly_Golightly replied on Thu Jan 28, 2010 @ 7:53pm |
 Coolness: 158680 | if taxes are 17%...
you do 17% of 12.00 = 17/100=?/12.00= 2.04$ prix du produit 12.00 - prix de la taxe 2.04= 9.96$ |
| I'm feeling hitched right now.. | |
| Good [+1]Toggle ReplyLink» Screwhead replied on Thu Jan 28, 2010 @ 7:54pm |
 Coolness: 685535 | quebec taxes are lame; one is applied first, then the other over that, so we're taxed on tax.. |
| I'm feeling like a drama magnet right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Thu Jan 28, 2010 @ 7:57pm |
 Coolness: 2603930 | 10$ * 5% = 10.50 (GST)
10.50 * 7% = 11.24 (QST) The increase in the QST rate to 8.5% will apply to the tax payable as of January 1, 2011. In Alberta there is 0% PST... Why do we have to pay all these taxes in Quebec? Greedy politicians? |
| I'm feeling nuclear right now.. | |
| Good [+1]Toggle ReplyLink» El_Presidente replied on Thu Jan 28, 2010 @ 8:01pm |
| Coolness: 299270 | If possible I'd like the resulting formula as an algebra equation so I can apply it to my excel sheet |
| I'm feeling the president right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Thu Jan 28, 2010 @ 8:03pm |
| Coolness: 2603930 | =((A1 * 1.05) * 1.07)
Where A1 = CELL |
| I'm feeling nuclear right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Thu Jan 28, 2010 @ 8:05pm |
| Coolness: 2603930 | You can also have a TAX cell
A1 = TAX CELL =1.05 * 1.07 A2 = VALUE OF UNIT 10.00 A3 = VALUE OF UNIT * TAX =A2*A1 Changing the TAX cell will change all values in your table... |
| I'm feeling nuclear right now.. | |
| Good [+1]Toggle ReplyLink» El_Presidente replied on Thu Jan 28, 2010 @ 8:14pm |
| Coolness: 299270 | Actually I want to de-calculate the tax.
I already know the amount of the total with tax. I want to find out the sub-total by using the total |
| I'm feeling the president right now.. | |
| Good [+1]Toggle ReplyLink» Screwhead replied on Thu Jan 28, 2010 @ 8:26pm |
| Coolness: 685535 | I'm not sure which tax is applied first or second (like I said we're taxed on tax here) so:
if TPS is first and TVQ is second: (X/1.075)/1.05 so $12/1.075 = $11.62 $11.62/1.05 = $10.63 If it's TVQ first and TPS second then (X/1.05)/1.075 |
| I'm feeling like a drama magnet right now.. | |
| Good [+1]Toggle ReplyLink» El_Presidente replied on Thu Jan 28, 2010 @ 8:55pm |
| Coolness: 299270 | Thanks screwhead! works perfectly |
| I'm feeling the president right now.. | |
| Good [+1]Toggle ReplyLink» rawali replied on Thu Jan 28, 2010 @ 9:17pm |
 Coolness: 140630 | Originally Posted By BETTY_HAZE
if taxes are 17%... you do 17% of 12.00 = 17/100=?/12.00= 2.04$ prix du produit 12.00 - prix de la taxe 2.04= 9.96$ that would happen to be slightly off... ex.: if you calculate 15% of 100$ you get 15$ right... so assuming that, 85$ would be 100$ pre 15%... but 15% of 85$ isnt 15$, 15% of 85$ is 12,75$... so 85$ plus 15% is 97,50$... calculating what amount you need to have 100$ with an included 15% would be a lil' more complicated y=x+0,15x isolate x y=1,15x y/1,15=x so ex.: 100$/1,15 = 86,96 |
| I'm feeling lovely right now.. | |
| Good [+1]Toggle ReplyLink» flo replied on Fri Jan 29, 2010 @ 12:15am |
 Coolness: 146270 | I see there are some calculus geniuses in here :P
Wally is right: you're looking for the price X before the tax (say, 7%) was applied, which gave 1.07*X ; Let Y be that total price (12$ in your original example), so Y = 1.07*X, hence X = Y/1.07 That's assuming Quebec's tax is applied last (which I've never known); if not, apply this division twice. |
| I'm feeling fresh doctor :) right now.. | |
| Good [+1]Toggle ReplyLink» kwickStah replied on Fri Jan 29, 2010 @ 6:46am |
 Coolness: 65490 | on calcule la tvq par dessus la tps :) |
| I'm feeling pregnant right now.. | |
| Good [+1]Toggle ReplyLink» basdini replied on Fri Jan 29, 2010 @ 9:55am |
 Coolness: 145145 | i is good and the maths! |
| I'm feeling surly right now.. | |
| Good [+1]Toggle ReplyLink» Holly_Golightly replied on Fri Jan 29, 2010 @ 2:47pm |
| Coolness: 158680 | Originally Posted By FLO
I see there are some calculus geniuses in here :P Wally is right: you're looking for the price X before the tax (say, 7%) was applied, which gave 1.07*X ; Let Y be that total price (12$ in your original example), so Y = 1.07*X, hence X = Y/1.07 That's assuming Quebec's tax is applied last (which I've never known); if not, apply this division twice. oupsy i was more into searching for a % of something hehe.. and it's true i totally forgot that taxes in quebec are charged 1 after the other.. hey Flo! i wanted to ask you but don't know if you'll check back that convo...: est ce que tu connais un band francais nomme Dirty Fingers Licked? je sais que tu as un band en france so j'etais curieuse p-e tu les connaissais?! |
| I'm feeling hitched right now.. | |
| Good [+1]Toggle ReplyLink» flo replied on Fri Jan 29, 2010 @ 2:56pm |
| Coolness: 146270 | Originally Posted By BETTY_HAZE
hey Flo! i wanted to ask you but don't know if you'll check back that convo...: est ce que tu connais un band francais nomme Dirty Fingers Licked? je sais que tu as un band en france so j'etais curieuse p-e tu les connaissais?! hmmm non je connais pas ça... et j'ai plus de band en France, chuis 100% Québécois maintenant :D |
| I'm feeling fresh doctor :) right now.. | |
| Good [+1]Toggle ReplyLink» Holly_Golightly replied on Fri Jan 29, 2010 @ 3:15pm |
| Coolness: 158680 | awwwww bien bienvenue au Quebec ds ce cas! :) |
| I'm feeling hitched right now.. | |
| Good [+1]Toggle ReplyLink» Masa replied on Fri Jan 29, 2010 @ 3:29pm |
 Coolness: 158715 | Says the expat living in Washington or sumthin'. :p |
| I'm feeling my swagga back right now.. | |
| Good [+1]Toggle ReplyLink» Holly_Golightly replied on Fri Jan 29, 2010 @ 3:45pm |
| Coolness: 158680 | hehe 0_* |
| I'm feeling hitched right now.. | |
| Good [+1]Toggle ReplyLink» flo replied on Sat Jan 30, 2010 @ 1:50am |
| Coolness: 146270 | heheh :) merci ! |
| I'm feeling fresh doctor :) right now.. | |
I Suck At Math: Decalculating Quebec Sales Tax
[ Top Of Page ] |
Post A Reply |
You must be logged in to post a reply.
[ Top Of Page ] |
