0
Thanks

A few words of thanks would be greatly appreciated.

The simple Excel formulas (calculation VAT inclusive)

In this article we will take a quick look at simple formulas in Excel, especially the calculation of VAT and inclusive of the sale price (including tax) for a purchase price without VAT (tax).


Method

  • Double click Excel icon on the desktop or the Start menu => All Programs.

  • A new Excel document appears: we will make a summary invoice of purchase of the computer company Kioskea.

  • The company bought: 4 PCs for 395.75€, 2 Phones for 869.50€, 6 USB for 22.50€, 4 flat screens for 315.00€ and 4 memory arrays for 58.00 €. We will put the result of Total Cost HT, for example, on cell D13.

  • So, for this example we'll use the function: =SUM (B13 * C13)

  • Explanation: = sum (unit price multiplied ht (*) amount), then click on keyboard input.

  • Apply the formula: click on cell D13 (in our example)and then go to the bottom right of the cell till the black square, cursor will turn into a black cross. Hold the left mouse button and drag the handle until the cell D17 release, then we have the result of Totals HT<bold>.

  • <bold>Calculate the VAT: we will put on cell E13, for example, the result of VAT. So, enter the formula =SUM (D13 * 19.6%), and then click on keyboard input and follow the same procedure as in the previous step.


  • Calculation of VATprice for each item : We will put on cell F13 the result of price Taxes.

    • 1st solution: enter the formula =SUM(D13: E13).
    • 2nd solution: use the tool AutoSum and select the cell to add.
  • Calculation of Total VAT invoice: we will put on cell F18 (in our example) the result of Total Taxes. Enter the formula =SUM(F13: F17).



Photo: © Everypixel
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
This document, titled « The simple Excel formulas (calculation VAT inclusive) », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!