What is the formula for VAT in Excel?

In Cell F2, write this formula and hit enter. The formula for selling price is ‘Cost+Taxes’ (neglecting profit here). We are assuming that VAT is only tax that is applied to your product. Then the cost is Purchase +VAT amt Taxes.

Leave a Reply

Your email address will not be published. Required fields are marked *