Formula to Remove the VAT in Excel How to remove VAT? To solve this, you don't need a specific Excel function. A combination of additions and divisions do the job.