Question: what is the excel formula to add 20 vat?
Answer: The most efficient formula we can use to express this is to divide the gross amount by 120%. However, we only want to do this if the VAT Rate in Column B is 20%. Using this formula, any expenses with a VAT rate of 0% will display the same net total and gross total.