![]() ![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |