![how to use microsoft excel to calculate how to use microsoft excel to calculate](https://www.exceltip.com/wp-content/uploads/2013/07/01.png)
![how to use microsoft excel to calculate how to use microsoft excel to calculate](https://cdn.corporatefinanceinstitute.com/assets/Basic-Excel-Formulas-for-Beginners-Sum-Function-1.png)
#How to use microsoft excel to calculate how to
Once again, you need to format the Excel cells correctly, entering the original and discounted price as Currency while the cell with the discount percentage in like Percentage (Alternatively, you can insert the% symbol at the end of the formula.) How to calculate the total from the percentage and the amountĪnother type of calculation that Excel offers is to discover a total from a percentage and an amount. In practice, instead of B2 you will have to enter the discounted price and instead of A2 the original price. The operation to be carried out in the spreadsheet is quite simple, since it will be enough to calculate the difference between the original price of the product and the reduced price using another formula, namely = (1-B2 / A2). In short, we have to calculate the percentage of discount applied to a good from its original price and the discounted price. Now we are going to see how to calculate the percentage in Excel trying to do a reverse calculation than the one we just showed. How to calculate the percentage of a value in Excel To ensure that the result is correct, always remember to write the figure for the net price and the VAT value in Currency format and the VAT percentage cell in Percentage format. Obviously, our example must be adapted according to the cells in which the net price and the VAT percentage have been entered: if they are in cells A3 and B3 the formula will be = A3 * B3.