How to calculate discounts in Excel

Microsoft Excel is a program that has various tools to help you calculate discounts of products, services or other activities that require it.

Therefore, in the next post we will teach you how to get discounts with this toolwhich leads to a short and easy step by step to execute.

Calculating the discount

To calculate this operation Through Microsoft Excel, you need to designate a column for quantity, discount, and product. In this case, 75% of 260 will be measured, which are in rows B2 and A2 respectively. To carry out this process, just multiply the percentage by the total and divide the result by 100.

In the program, the formula to executeaccording to the rows and columns in which said digits are found, would be the following: “=A2*B2/100”. In this tutorial, 195 was obtained.

Subtracting the discount from the quantity

Now, to know what the total discount is, It is essential to subtract the product of the percentage, to the amount established. Continuing with the previous example, the formula to execute is: “=B2-C2”, the result of which is 65. However, This process can be done directlyallowing both sets to be calculated easily.

To do so, it will be necessary to create a cell directed to the discount, total and the reduction obtained. However, The percentage must be made in decimals, being in this case 0.75. Consequently, the formula is: “=A2-(A2*B2)”, which offers the same result (65).

Applying discounts to an entire cell

To apply discounts on an entire cell in Excel with various quantities, The percentage must be expressed in decimals, being 0.75 in this tutorial. Taking this into account, The formula to use is: “=A2-(A2*$B$2)”. In this way, in the section corresponding to the result, the product of all operations will be obtained automatically.

Other alternatives

If you want to opt for a procedure that does not require Microsoft Excel, There are various percentage calculators that can be used online. Some of these are , and . They only require adding the quantities along with their discount to give the result.

Knowing how to get discounts in Microsoft Excel will allow you to obtain the product of these operations quickly and easily.