Question: what is the excel formula for vat at 20?
Answer: This means that a value of 0.2 will be displayed as 20%. 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%. However, we only want to do this if the VAT Rate in Column B is 20%.