Discounts are a great way to save money on your purchases. By understanding how to calculate discounted prices, you can make informed decisions and take full advantage of sales and promotions. Below is a table demonstrating how to set up a simple discount calculator in Excel.
How to Calculate Discounted Prices
To calculate the discounted price, you can use the formula:
Discounted Price = Original Price - (Original Price * Discount Rate)
Here's a simple breakdown of the formula:
- Original Price: The initial price of the product.
- Discount Rate: The percentage discount offered, expressed as a decimal.
- Discounted Price: The final price after the discount is applied.
Here is a sample table showing how the Excel sheet should be designed:
Exercise
Enter the Discount Rate as a percentage in column C.
Solution
In column D, use the formula to calculate the Discounted Price:
=B2 - (B2 * C2 / 100)Drag the formula down to apply it to the other rows.
This setup will allow you to easily input different items, their prices, and discount rates to see the final discounted prices automatically.