Cara Menghitung Diskon di Excel

>Hello Sohib EditorOnline, welcome to the ultimate guide on how to calculate discounts in Excel. In this article, we will walk you through the steps on how to calculate discounts in Excel and provide you with useful tips and tricks that you can use in your daily work. Let’s dive in!

What is Discount?

Before we get started, let’s define what discount means. A discount is a reduction in the original price of a product or service that is offered by a seller to a buyer. Discounts can be expressed as a percentage or a fixed amount, depending on the terms and conditions of the sale.

In Excel, discounts are commonly used in sales and accounting to calculate the final price of a product or service after deducting the discount.

Types of Discount

There are two types of discounts that are commonly used in Excel: percentage discount and fixed amount discount.

A percentage discount is when the seller offers a percentage reduction on the original price, while a fixed amount discount is when the seller offers a fixed amount reduction on the original price.

How to Calculate Percentage Discount in Excel

The formula to calculate percentage discount in Excel is:

Parameter	Formula
Original price	OP
Discount rate	DR
Discount amount	DA = OP * DR
Final price	FP = OP – DA

Step-by-step Guide to Calculate Percentage Discount in Excel

Follow these steps to calculate percentage discount in Excel:

1. Enter the original price of the product or service in a cell. For example, let’s say the original price is Rp100,000 and the cell is A1.
2. Enter the discount rate in percentage in a cell. For example, let’s say the discount rate is 10% and the cell is A2.
3. In a new cell, enter the formula to calculate the discount amount. The formula is “=A1*A2”. For example, let’s say the cell for the discount amount is A3.
4. In a new cell, enter the formula to calculate the final price. The formula is “=A1-A3”. For example, let’s say the cell for the final price is A4.
5. The final price with discount will be displayed in the cell for the final price (A4).

Example of Calculating Percentage Discount in Excel

Let’s say you want to calculate the final price with a 10% discount on an item that originally costs Rp100,000.

1. Enter 100,000 into cell A1.
2. Enter 10% into cell A2.
3. Enter “=A1*A2” into cell A3.
4. Enter “=A1-A3” into cell A4.
5. The final price after discount should be displayed in cell A4, which in this case is Rp90,000.

How to Calculate Fixed Amount Discount in Excel

The formula to calculate fixed amount discount in Excel is:

Parameter	Formula
Original price	OP
Discount amount	DA
Final price	FP = OP – DA

Step-by-step Guide to Calculate Fixed Amount Discount in Excel

Follow these steps to calculate fixed amount discount in Excel:

1. Enter the original price of the product or service in a cell. For example, let’s say the original price is Rp100,000 and the cell is A1.
2. Enter the discount amount in a cell. For example, let’s say the discount amount is Rp10,000 and the cell is A2.
3. In a new cell, enter the formula to calculate the final price. The formula is “=A1-A2”. For example, let’s say the cell for the final price is A3.
4. The final price with discount will be displayed in the cell for the final price (A3).

Example of Calculating Fixed Amount Discount in Excel

Let’s say you want to calculate the final price with a fixed amount discount of Rp10,000 on an item that originally costs Rp100,000.

1. Enter 100,000 into cell A1.
2. Enter 10,000 into cell A2.
3. Enter “=A1-A2” into cell A3.
4. The final price after discount should be displayed in cell A3, which in this case is Rp90,000.

FAQ

Q: How do I apply the discount to multiple items in Excel?

A: To apply the same discount to multiple items in Excel, you can use the fill handle to copy and paste the formulas from one cell to another. Simply select the cell with the formula, and drag the fill handle to the cells that you want to apply the formula to.

Q: What if I want to apply different discounts for different items in Excel?

A: If you want to apply different discounts for different items in Excel, you can use the IF function to create a formula that applies different discounts based on certain conditions. For example, if the original price is greater than Rp50,000, apply a 10% discount; if the original price is less than or equal to Rp50,000, apply a 5% discount.

Q: Can I use Excel to calculate discounts for bulk purchases?

A: Yes, you can use Excel to calculate discounts for bulk purchases. To do this, you can create a formula that calculates the final price based on the number of items purchased. For example, if a customer purchases 10 items, apply a 20% discount; if a customer purchases 20 items, apply a 30% discount.

Q: What if I want to reverse calculate the original price after applying a discount in Excel?

A: To reverse calculate the original price after applying a discount in Excel, you can use the following formula:

OP = FP / (1 – DR)

Where OP is the original price, FP is the final price after discount, and DR is the discount rate in decimal form (e.g. 0.1 for 10%).

Conclusion

Calculating discounts in Excel is a useful skill that can save you time and simplify your work. With the formulas and tips provided in this article, you can easily calculate percentage and fixed amount discounts in Excel and apply them to multiple items or bulk purchases. We hope you found this guide helpful, and feel free to leave a comment if you have any questions or suggestions.

Cara Menghitung Diskon di Excel