Someone made this sheet for me soI can use it to enter my business taxes revenue and spendings for tax purposes.
Our Federal tax is 5% and have not changed ever since he did it. But our provincial taxes have risen from 7.5% to 8.5% in 2011, and have risen again to 9.5% in 2012. Therefore, I need to learn how to change the % of the provincial taxes for 2011 as 8.5% and for 2012 to 9.5%, And have it applied all over the sheet where it should be under TVQ? The current one shows as =SUM(C10*$M$2).
Please help me change the formula of the tax % so it can calculate my amount automatically when entered showing the amount before taxes and the amount after taxes and showing the TPS and TVQ??
As you can see below the TPS is at 5% and the TVQ is at 7.5%...which I need to change to 8.5%....The formulas shows as =SUM(C10*$M$2) for TVQ and shows =SUM(C10*$M$1) for TPS. Please help me or show me the steps to change it so it applies automatically all over the sheet as per below example??
|2/Oct/11||Assurance voiture||40.51 $||1.79 $||2.83 $||35.89 $|
|- $||- $||- $|
|6/Oct/11||Shell Canada||60.00 $||2.66 $||4.19 $||53.16 $|
|14/Oct/11||Stationnement Crescent||14.00 $||0.62 $||0.98 $||12.40 $|
|14/Oct/11||SPAQ machine antoine||21.00 $||0.93 $||1.47 $||18.60 $|