While some manage to do simple math calculations in their heads, many face difficulties when working with percentages. For both cases, the Excel can be a great facilitator in using percentages of larger numbers or also smaller operations that appear in the middle of a worksheet.
The important thing is to know that the calculation methods are exactly the same as what we would have to do on paper or on the calculator, however, in this case, we will use formulas from the program to facilitate the visualization of the information with references. Learn below how to calculate percentage in Excel:
To begin, let's recall the concept of percentage: a comparison index between a value and a total.
It is also possible to represent the number that is in decimal as a percentage, through the "Percentage Style" button, in the subgroup "Number" in the "Home" tab.
Excel allows us to do any operation involving percentage, so let's see the practical application of some of the most common.
The 3 rule will follow the same rule as we normally use. In the example we will calculate how much percent represents the number 50 if the number 200 represents 100%.
Difference of two numbers with percentage
Let's now calculate the percentage difference between 500 and 300.
Using the formula we came to the conclusion that 500 is 67% greater than 300. This calculation is useful for comparing a company's expenses or revenues from one period to another.
We will calculate the total discount obtained based on the initial value of the product and the discount percentage granted.
After this, we can calculate the amount paid, discounting the discount value of the initial value.
And applying to all products.
It is also possible to perform the calculation of the Payment Amount without the need to calculate the discount amount in advance, according to the following formula.
Percentage operations are very diverse and can be used for a variety of purposes, but the basis for all is the same. So, from the given examples you will get the most out of Excel!
Are you in doubt? Get in on LUZ Excel Forum and send your question!