• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Calculate 10 Percent Discount in Excel (With Easy Steps)

March 31, 2024 by admin Category: Top

You are viewing the article How to Calculate 10 Percent Discount in Excel (With Easy Steps)  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

How to Calculate 30 Percent Off a Price on Calculator
How to Calculate 30 Percent Off a Price on Calculator

Discount Calculation is one of the formulas which frequently utilize Excel. Excel makes it simpler and quicker to perform the calculations related to discounts. We know that, for both simple and complex computations, Microsoft Excel is an effective tool. It makes it simple to calculate percentage values, such as discount percentages. In this article, we will demonstrate the procedures to calculate a 10 percent (10%) discount in excel.

Table of Contents

  • Download Practice Workbook
    • Step 1: Create Dataset
    • Step 2: Input Formula
    • Final Output
  • Things to Remember
  • Conclusion

Download Practice Workbook

You can download the workbook and practice with them.

Step by Step Procedures to Calculate 10 Percent Discount Price in Excel

A discount is a subtraction from a specific sum. Therefore, being able to compute a discount allows us to determine how much money we are saving from another dollar amount. Let’s follow the process to calculate discounted prices in excel.

Step 1: Create Dataset

To see the calculation of a 10 percent discount in excel. We just need a dataset.

  • In the first place, we list down some items in column B.
  • Then, we put the price for each cell in column C.
  • And, the 10% discount for each item is in column D.
  • To calculate the discount price, we have inserted a new column (column E) named Discounted Price.
  How to find the original value before percentage off

Read More: How to Calculate Discount in Excel (2 Easy Methods)

READ More:   3 ways to cook delicious and irresistible pork wine sauce

Step 2: Input Formula

For the purpose of discount percentage calculation, we may use a simple formula. The formula to get the discount % is.

  • To begin with, select the cell where you want to put the formula for the calculation of the 10% discounted price. So, we select cell E5.
  • Then, put the formula into that selected cell.

=C5-(C5*D5)

  • Further, press Enter to see the result.
  • Next, drag the Fill Handle down to duplicate the formula over the range. Or, to AutoFill the range, double-click on the plus (+) symbol.

Read More: Formula to Calculate Discount Percentage in Excel

Final Output

Now, let’s look at the final output using the simple formula to calculate a 10% discounted price.

  • Finally, we can see the discount price for each item in column E.

Note: Sometimes we don’t have the discount percentage showing in the dataset, but the customer gets a 10% discount for a specific item. For this, you can also calculate the discounted price by just using .01 instead of using the 10%.

  Discount Calculator

How to Calculate Original Price from 10 Percent Discount in Excel

A product’s true price may need to be determined in specific circumstances based on a specified reduced price and discount %. We will look at how to achieve it in this section.

STEPS:

  • Firstly, choose the cell where you wish to enter the formula to determine the original price of 10%. Thus, we choose cell E5.
  • Secondly, enter the formula into the cell you just chose.

=1/(1-C5)* D5

  • Thirdly, press Enter once again to view the outcome.
  • Further, to replicate the formula throughout the range, drag the Fill Handle downward. To AutoFill the range, double-click on the plus (+) symbol.
  • Finally, column E displays the original price for each item.
READ More:   How to make fresh and delicious salmon salad with dragon fruit sauce

Read More: How to Calculate Discount Rate in Excel (3 Quick Methods)

Things to Remember

  • Applying the Percentage format to the cells will allow you to display a number in Excel as a percentage. For this, simply pick the desired cells. And then, go to the Home tab from the ribbon. Choose the Percent Style (%) button in the Number group.
  • You may adjust the decimal place as necessary. For that, click on Decrease Decimal or Increase Decimal for rounding.
  • Excel always keeps the numeric value as a fundamental value. Therefore, even if you formatted a number to show something as a percentage (10%), all that is happening is formatting or a visual meaning of the true value. Excel automatically makes computations on that decimal’s fundamental number (0.1). To solve this, pick the cell, and press Ctrl + 1. Then, check the Text box under the General menu to confirm the fundamental value.
  Percent Off Calculator

Conclusion

The above procedures will assist you to Calculate 10 Percent Discount in Excel. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback. Or you can have a glance at our other articles in the ExcelDemy.com blog!

Thank you for reading this post How to Calculate 10 Percent Discount in Excel (With Easy Steps) at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

Related Search:

Related Posts

Bernd Leno: Hành Trình Sự Nghiệp Của Thủ Môn Tài Năng
Bernd Leno: Hành Trình Sự Nghiệp Của Thủ Môn Tài Năng
Dominic Calvert-Lewin: Ngôi sao sáng giá của bóng đá Anh
Dominic Calvert-Lewin: Ngôi sao sáng giá của bóng đá Anh
Nguyễn Thị Oanh – Ngôi sao sáng của điền kinh Việt Nam
Nguyễn Thị Oanh – Ngôi sao sáng của điền kinh Việt Nam

Category: Top

Previous Post: « 18 how many valence electrons in zinc Full Guide
Next Post: Sara Hall falls short of Olympic goal in women’s 10,000-meter qualifier »

Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge