Mona has attended:
Excel Intermediate course
VAT
How do you calculate VAT and what is the formula sign for divide
RE: VAT
Hi Mona,
Welcome to the forum, I hope you enjoyed your course. In response to your post:
Divide = / (the forward slash)
Don
RE: VAT
Hi Mona,
To calculate VAT, you multiply the ex-vat value by 0.20 (assuming VAT rate is 20%)
In Excel, if the ex-vat price is in cell A1, then to calculate the VAT you could use a formula such as =A1*0.20
To have a variable VAT rate, you could have 0.20 in another cell, such as B1, and then use a formula such as =A1*B1 to work out VAT.
If you then want the total inc. vat price, you can have another cell with =A1+A2 to work out the total (Assuming your VAT calculation was in A2).
Hope that helps.
Regards, Rich
