From there we have the above calculation.Īccordingly based on the example that TipsMake gives us the following calculation: = A2-A2 * B2 / 100 In which the discounted amount is calculated by multiplying the original amount by the discounted percentage. To calculate the amount of money to collect after the discount we will subtract the amount of the original discount. Guest amount = Base price - Base price x percentage discount With A2 and B2 respectively the original price and% discount are given.įinally, you can easily copy the used formula down the lines below to calculate the entire discount list.Īlso based on a percentage calculation algorithm, but here we will have a calculation that is different from the calculation in method 1.
Based on that we can give the calculation as above.Īccordingly, you can use Excel to create a percentage discount calculation, based on the following example we have the calculation: = A2 * ((100-B2) / 100) If your item is discounted by some x%, then after making money you can only receive (100-x)% only.įor example, if the item is 20% off, the purchase price is 80% of the original price. Method 1īefore going into the tutorial of calculating percentage discount with Excel we need to understand the algorithm will be used here first.įirst, when you want to calculate the amount after the discount, you need to know the original price of the item and the% discount.įrom there we will have the following calculation: Amount of guests collected = Original price x ((100-percent discount) / 100)
There are two methods of calculation so that you can use the% discount to calculate the amount of money that you will get after customers' promotions when they buy.
#BUY KUTOOLS EXCEL CHEAP COUPON HOW TO#
Let's learn how to calculate the percentage (%) of the fastest and most standard discount. During the sales process, you can use Excel to inventory goods and take advantage of this calculation method to calculate the discount percentage for your item as quickly and correctly as possible.
0 kommentar(er)
