Question: what is the formula to work out vat on excel?
Answer: Assuming your VAT rate is 20% then multiply the net price by 0.2 to get the tax or 1.2 to get the gross. So, if your net price is in cell A1 then typing “=A1*0.2” into A2 will give the tax only in A2. Typing “=A1*1.2” into A3 will give the gross price. Amount divided by 1+VAT%.