Question: what is the formula for working out vat in excel?
Answer: VAT calculations work on the premise that the gross amount is 120% of the net amount. The most efficient formula we can use to express this is to divide the gross amount by 120%.