Better experience in portrait mode.

How to Calculate Percentages Manually and Using Excel, Useful for Calculating Discounts

kapanlagi
How to Calculate Percentages Manually and Using Excel, Useful for Calculating Discounts Illustration (credit: unsplash)

Kapanlagi.com - Mathematics is often a subject that students fear. This is because in mathematics lessons, there are many formulas that are sometimes difficult to understand and memorize. In addition, calculations in mathematics also require students to be more careful. Among the many topics in mathematics, calculating percentages is one that often confuses people.

Learning how to calculate percentages is also very important, as this material will be very useful for everyday life. Compared to other subjects, calculating percentages is actually quite easy. However, to find the right answer, you need to calculate it carefully and accurately.

Summarized from liputan6.com, here is a summary of how to calculate percentages that are easy to understand.

1. Understanding What Percent Is

To be able to calculate percentages easily, we first need to understand the concept of percent. Simply put, percent is a numerical form used to describe a part or whole of a numerical data. Percentages are expressed in per hundred. Generally, percentages are represented by the symbol %.

Based on the brief explanation above, 60% represents a description of 60 per hundred. For example, if a data states that a school has 60% female students, it means that 60 out of 100 students in that school are female.

 

2. How to Calculate Percentages Manually

Compared to calculations in other mathematics, calculating percentages is actually relatively easy. The formula for calculating percentages is the amount of the percentage number is equal to the partial amount divided by the total amount, then multiplied by 100%. Or, more concisely as follows:

Percentage (%) = Partial Amount/Total Amount x 100%

To better understand, consider the following example and its solution:

A jar contains 1500 blue candies and 350 red candies. So the total number of candies in the jar is 1850. This number 1850 is equal to 100%. Then what is the percentage value of the blue and red candies?

The solution to the problem can be done using the formula above. Therefore, the calculation method is as follows:

1) How to calculate the percentage of blue candies:

Percentage of Blue Candies = Number of Blue Candies/Total Number of Candies x 100%

Percentage of Blue Candies = 1500/1850 x 100% = 0.82 x 100% = 82%

Percentage of Blue Candies = 82%

2) How to calculate the percentage of red candies:

Percentage of Red Candies = Number of Red Candies/Total Number of Candies x 100%

Percentage of Red Candies = 350/1850 x 100% = 0.18 x 100% = 18%

Percentage of Red Candies = 18%

 

3. How to Calculate Percentages Using Excel

Currently, calculating percentages can be done not only manually. You can use tools such as a calculator or Ms Excel on a computer. Unfortunately, many still do not know how to calculate percentages using Excel. However, this method is considered easy and effective for calculating large amounts of data.

To calculate percentages using Excel, you can use the percentage format on the Excel worksheet. To do this, simply click on the "%" icon in the Number group on the Home tab, or press Ctrl+Shift+%.

If you want to format an Excel cell that already contains a number, Excel will multiply that number by 100 to automatically convert it into a percentage. So, for example, if a cell in Excel contains the number 10, Excel will multiply that number by 100, resulting in the number 1000.00% after applying the percentage format.

Therefore, to ensure accurate percentages, it is recommended to first convert the number format into decimal form. This is because percentages are calculated using the equation amount / total = percentage. So, if you format 0.1 as a percentage, it will be correctly displayed as 10%.

 

4. How to Calculate Percentage on Discounts

In daily life, percentage calculations are often used for various purposes. One of the most common uses of percentage formulas is to calculate discounts in shopping centers, which are often expressed in percentages. To better understand how to calculate discount percentages, consider the following example and explanation.

A product has an original price of Rp 100,000 with a 20% discount. How do you calculate the value of 20% of the original price of Rp 100,000?

To find the discount value, you can use the formula:

Discount value = (percentage discount) x (original price)

Therefore, the calculation is as follows:

Discount value = (20/100) x Rp 100,000

Discount value = 0.2 x Rp 100,000

Discount value = Rp 20,000

However, there are times when discounts in shopping centers are expressed in tiers, such as 50% + 30%. In that case, how do you calculate it? For a clearer understanding, consider the following example and solution.

A pair of pants with a price of Rp 500,000 is discounted by 50% + 30%. How much is the total amount to be paid?

1) Calculating the value of the first discount:

Value of the first discount = (percentage discount) x (original price)

Value of the first discount = (50/100) x Rp 500,000

Value of the first discount = 0.5 x Rp 500,000

Value of the first discount = Rp 250,000

2) Calculating the value of the second discount:

The value of the second discount means 30% of Rp 250,000

Value of the second discount = (percentage discount) x (value of the first discount)

Value of the second discount = (30/100) x Rp 250,000

Value of the second discount = 0.3 x Rp 250,000

Value of the second discount = Rp 75,000

Therefore, the total discount for the product is Rp 250,000 + Rp 75,000 = Rp 325,000.

Those are some explanations about how to calculate discounts. Hopefully useful and can increase insight.

 

(kpl/gen/psp)

Disclaimer: This translation from Bahasa Indonesia to English has been generated by Artificial Intelligence.
Swipe Up Next Article

Cobain For You Page (FYP) Yang kamu suka ada di sini,
lihat isinya

Buka FYP