# Need help calculating something in Excel

Status
Not open for further replies.

#### MysteryManX93

##### Honorable
Wasn't sure if this is the correct section, so please do move if required.

Basically, I would like to calculate a cell that takes a value from a sub-total cell, into a cell that would add 20% VAT to it, to make a total.

#### jimmysmitty

##### Distinguished
Moderator
=SUM(H3+(H3*A1))

That is one way to do it. However you need to have the 20% in a cell.

Another way is: =SUM(H3*1.2) since the VAT rate is 20% flat that could be the easiest way to do it.

#### p_nut_uk

##### Estimable
Little confused over what your asking but say you had £10 minus vat you could put something like =sum(H3*1.2) that would equal £12 with VAT

If you had a total plus vat for example £12 and you wanted the vat amount displayed you could put =sum(H3/6) which would display (£)2

#### martinch

##### Estimable
Using your example, "=H3 * 1.2" , assuming you're wanting one cell per line?

#### boosted1g

##### Honorable
I don't know if VAT changes in Canada like the tax rate changes all the time in the USA.

For a long term solution you would simply have a cell that you designate as the VAT/Tax percentage, for the example say it is in k2

You then have in Column G instead of Total incl vat you would have "Subtotal", the formula for that would be = c3*(e3-d3)
In column H you would just have VAT, formula would be = g3*\$k\$2
In column I you would have Item Total, formula would be = g3+ h3

Status
Not open for further replies.
Apps General Discussion 2
Apps General Discussion 1
Apps General Discussion 5
Apps General Discussion 3
Apps General Discussion 1
Apps General Discussion 2
Apps General Discussion 5
Apps General Discussion 4
Apps General Discussion 2
Apps General Discussion 1
Apps General Discussion 1
Apps General Discussion 8
Apps General Discussion 3
Apps General Discussion 1
Apps General Discussion 5
Apps General Discussion 12
Apps General Discussion 4
Apps General Discussion 3
Apps General Discussion 6
Apps General Discussion 18