Kioskea
Recherche
Ask a question »

The simple Excel formulas (calculation VAT inclusive)

February 2015

A quick look with simple formulas in Excel, and especially the calculation of VAT and inclusive of the sale price (including tax) for a purchase price without VAT (tax). Double click Excel icon on the desktop or the Start menu => All Programs.

A new document Excel appears: We will here make a summary invoice of purchase of the computer company Kioskea. The company we bought 4 PC € 395.75, € 869.50 for 2 Phones, 6 USB to 22.50 €, 4 flat screens € 315.00 and 4 memory arrays to 58.00 €. We will put on the cell D13 (in our example) or we have the result of Total Cost HT

Then for this example we'll use the function = SUM (B13 * C13)
Explanation: = sum (unit price multiplied ht (*) amount), then click on keyboard input.

Reproduce the formula:
Click on cell D13 (in our example) then position you in the bottom right of the cell on the black square, your cursor turns into black cross, hold the left mouse button and drag the handle until the cell D17 release, we have the result of any totals HT.

We will now calculate the VAT
We will put on the cell E13 (in our example) or we have the result of VAT
and enter the formula = sum (D13 * 19.6%), and then click on keyboard input.
Use replicate the formula as indicated on the explanation above


Calculation of VAT price for each item :
We will put on the cell F13 (in our example) or we have the result of price Taxes
1st solution: enter the formula = sum (D13: E13) ,
2nd solution: tool AutoSum and select the cell to add, then click on keyboard input.
Use replicate the formula as indicated on the explanation above

and finally the calculation of Total VAT invoice :
We will put on the cell F18 (in our example) or we have the result of Total Taxes
and enter the formula = sum (F13: F17), or the tool utis AutoSumand select the cell to add, then click on keyboard input.
For unlimited offline reading, you can download this article for free in PDF format:
The-simple-excel-formulas-calculation-vat-inclusive.pdf

See also

In the same category

Published by aakai1056 - Latest update by Jeff
This document entitled « The simple Excel formulas (calculation VAT inclusive) » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.