Calculate percentage discount in Excel - Excel Tips and Tricks

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.



How to calculate percentage discount in Excel?,How do you take 20% off in Excel?,What is the formula for discount%?,How to find 10% of a number in Excel?,How do I calculate 5% of a number in Excel?,How to calculate 10 percent of a number?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks