Learn how to calculate percentage discount in Excel.

To calculate a percentage discount in Excel, you can use simple formulas like =C3*(1-C4) or =C3-(C3*C4). For example, to take 20% off a number, place the original value in cell C3 and 20% in cell C4, then use =C3*(1-C4) to get the discounted price. The formula for discount percentage is essentially =Original Price * (1 – Discount Percentage). To find 10% of a number in Excel, you can use =C3*0.10, and similarly, to calculate 5% of a number, use =C3*0.05. Both methods, =C3*(1-C4) and =C3-(C3*C4), work for calculating discounts, with the first multiplying the original value by the remaining percentage after discount and the second subtracting the discount amount directly from the original value.

Explain using theswe formula
Method 1
=C3*(1-C4)

Method 2
=C3-(C3*C4)

Method 1
=C3*(1-C4)

C3: This cell contains the original value or price. Let’s assume it holds the value 5 (similar to your initial example).

C4: This cell contains the discount percentage. Let’s assume it holds the value 1.7%.

(1-C4): This part of the formula calculates the remaining percentage after applying the discount.

1 represents 100% in decimal form.
C4 represents the discount percentage in decimal form (1.7% or 0.017).
Therefore, 1 – C4 calculates the remaining percentage. For C4 = 1.7% (or 0.017), the calculation is 1 – 0.017, which equals 0.983.
*C3(1-C4)**: This part multiplies the original value by the remaining percentage after the discount.

If C3 is 5 and (1 – C4) is 0.983, then the calculation is 5 * 0.983, which equals 4.915.
So, the formula =C3*(1-C4) effectively calculates the original value minus the discount percentage, giving the discounted value.

Method 2
=C3-(C3*C4)

This formula works as follows:

C3 * C4 calculates the discount amount.
C3 – (C3 * C4) subtracts the discount amount from the original value.
So, if C3 contains 5 and C4 contains 1.7%, the formula will yield 4.915.

Here’s how you should input it in Excel:

In cell C3, enter 5.
In cell C4, enter 1.7%.
In cell C1 (or any other cell where you want the result), enter the formula: =C3 – (C3 * C4).
The result in cell C1 should be 4.915.

#tips #excel #shorts #fyp

Please take the opportunity to connect and share this video with your friends and family if you find it useful.