Sunday , June 4 2023

How to calculate Percentages

We need to calculate percentages in academics, sells or purchase, finding discount, calculating taxes/Vat, shares etc. Sometimes it is required to find the percentage increase or decrease of any value. Percentage calculation formula is also used to calculate percentile or finding rank in a school. Therefore understanding percentage calculation basic helps in every walks of life.  There are various ways to calculate percentages depending upon the applications. You can also use a percentage calculator for ready-made solution to your problem.

Percentage Definition

In simple term Percentage is ( ‘per=every’, ‘cent=100’) a number expressed as fraction of 100. It is generally expressed by symbol ’%’.  For example 20% means 20 part out of 100. It used to compare two different data set. For example, in a class of 60 students, 25 are girls where as in another class of 50 students, 22 are girls, the first class has more numbers of girls (25>22) where as the second class has more percentage of girls student (41.67% < 44%) . Generally three basic types of percentage calculation is used every where. Percentages formula involved in all these types of calculation is described below with example, also  an online Percentage calculator is given below for ready-made answer for your percentage calculation.

 

Type-1 How to calculate percentage of a number X

Suppose Y % percentage of a number X is Z than

    \[ Z =\frac{Y}{100} .X  \]

For Example, 20% of 40 is (20/100).40=8

Type-2 How to calculate, what percentage of a number is X

Again Suppose Y % percentage  of a number X is Z than

    \[ Y= \frac{Z}{X}.100 \]

From above Example, 8 is 20% of 40.

Type-3 How to calculate the percentage increase or decrease from number A to B

    \[{Percentage increase} = \frac{B-A}{A}.100\]

    \[{Percentage decrease} = \frac{A-B}{A}.100\]

 

For example 20 to 30 increase means (30-20).100/20=50% increase

For example 50 to 30 decrease means (50-30).100/50=40% decrease

Methods & Tips To Calculate Percentage in Excel

In Microsoft Excel there is a shortcut for finding percentage of any fraction. For example take the case given in Percentage definition para mentioned above, use the formula in excel as shown below.

percentage in excel

Now format the Cell D2  and D3 and apply percentage. For that Either Right click on the Cell (D2/D3) and select percentage as shown below, or use the’%’ percentage shortcut given in latest version of Excel.

 

 

 

 

 

 

 

 

 

 

The Cell D2 and D3 will automatically give the percentage value as shown below. The below results will show that Class B has less numbers of Girls then Class A, but the percentage of Girls students in Class B is more than that of Class A.

result of percentage formula

 

Authored by howtocalculate

Check Also

10 Interesting Facts To Know About Photosynthesis

10 Interesting Facts To Know About Photosynthesis

All living things on this planet need energy to live and energy comes from food. ...

electricity bills

Calculate Power Consumption and Average Monthly Electricity Bills of Your Home

Every household that uses electricity needs to pay monthly electricity bills, which is important part ...

Leave a Reply

%d bloggers like this: