Excel, tax calculation
Jean-Guy Dupont
-
jc80 Posted messages 5063 Registration date Status Membre Last intervention -
jc80 Posted messages 5063 Registration date Status Membre Last intervention -
How do we calculate the automatic tax on an Excel spreadsheet? I was shown how to do it in class and I'm having trouble.
For example, if there are 10 amounts one below the other, sum them up and calculate the tax on the total amount.
Same thing for the average.
For example, if there are 10 amounts one below the other, sum them up and calculate the tax on the total amount.
Same thing for the average.
3 réponses
Hi,
for the sum:
let's assume your numbers are in cells A1 to A10, go to cell A11, type =SUM(A1:A10) or quicker, go to A11, type = and then use your mouse to highlight the cells from A1 to A10, then press enter
for your tax:
you can go to, for example, A13, type =A11 (the cell with your previously found sum)*8% (tax rate)
if your tax is fixed:
type, for example, 8% in cell C11, then type in cell A13 =$A$11*$C$11
there you go, hoping I don't make any mistakes because it's not easy off the top of my head ;-)
for the sum:
let's assume your numbers are in cells A1 to A10, go to cell A11, type =SUM(A1:A10) or quicker, go to A11, type = and then use your mouse to highlight the cells from A1 to A10, then press enter
for your tax:
you can go to, for example, A13, type =A11 (the cell with your previously found sum)*8% (tax rate)
if your tax is fixed:
type, for example, 8% in cell C11, then type in cell A13 =$A$11*$C$11
there you go, hoping I don't make any mistakes because it's not easy off the top of my head ;-)
Do you have an idea for calculating tax in reverse? I mean: If I have my total price that I paid, I would like to know the price before tax, and how much I paid for the tax?
Thank you
Total amount including tax 150 VAT 12% for the net amount 150/1.12=133.93
amount of VAT 150-133.93=17 euros
best regards