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).
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