How to calculate VAT / Tax and net sale price in Microsoft Excel





Enter sale price in cell A1: 100.00

Enter VAT / Tax in cell A2: 18.00%

Use the following function to calculate the net sale price: =A1/(100%+A2)

The result: 84.75

To calculate the VAT / Tax use the following function: =A1-A1/(100%+A2)

The result: 15.25



5 thoughts on “How to calculate VAT / Tax and net sale price in Microsoft Excel

  1. “100.00-18% = 82.00 NOT 84.75

    Try to find the net price:
    A1 100.00 B1 18.00% then try the formula=(100%-b1)*al answer 82.00 “

    • You are wrong. you cannot minus the 18% vat/tax directly to the gross amount. 18% is only added into net amount to get the gross price. the tutorial is correct.

      100.00 = gross sales
      18% = vat

      getting net sale price: 100.00/1.18 =84.75
      getting the VAT: 100.00/1.18*0.18 =15.25

  2. Tip is great. We all know how to add VAT onto the basic price, but I hadn’t a clue where to begin doing it the other way around. By the way – VAT is 17.5% in the UK.

Leave a Reply

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


eight × 8 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>