Need help calculating something in Excel

Status
Not open for further replies.

MysteryManX93

Honorable
May 16, 2013
1
0
10,510
0
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
Oct 5, 2007
551
0
19,010
42
=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
Oct 28, 2014
5
0
4,520
1
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
 
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.
Thread starter Similar threads Forum Replies Date
B Apps General Discussion 2
N Apps General Discussion 1
S Apps General Discussion 5
H Apps General Discussion 3
Y Apps General Discussion 1
N Apps General Discussion 2
L Apps General Discussion 5
B Apps General Discussion 4
M Apps General Discussion 2
O Apps General Discussion 1
N Apps General Discussion 1
A Apps General Discussion 8
D Apps General Discussion 3
M Apps General Discussion 1
N Apps General Discussion 5
E Apps General Discussion 12
hk3008 Apps General Discussion 4
truegenius Apps General Discussion 3
P Apps General Discussion 6
L Apps General Discussion 18

ASK THE COMMUNITY