Excel Formula of Percentage (Table of Contents)
Formula of Percentage in Excel
Percentage of any number is the value out of 100. If we want to calculate the percentage in excel, then we must divide the smaller numerical value with a bigger numerical value and then click on Percentage style which is available Home menu ribbon under Number section. There are few more ways by which we can calculate Increase By Percentage which we need to subtract the total value from 1 to get an actual percentage and Percentage Change where we need to subtract values from each other and then divide it by bigger number to get a percentage.
The mathematical Formula of Percentage is: (Numerator / Denominator) * 100
How to Implement Formula of Percentage in Excel?
Implementing Formula of Percentage in Excel is very easy and useful especially when we are working on spreadsheets of restaurants, reseller commissions, income taxes or interest rates.
we can implement the Formula of Percentage option by 3 methods.
Method #1 – Percentage Icon under Home Tab
- Under Home tab >> under Number Group >> Click on % icon to convert the numerical value of cell into Percent value.
Method #2 – Using Dialog Box Launcher
- Under Home tab >> under Number Group >> Click on Dialog box launcher icon.
- A dialog box of Format Cells will open. We need to select Percentage option.
- Select Number of decimal places as required. By default, it is 2. Then press OK.
Method #3 – Using Format Cells
- Select any cell.
- Right click on it and Select the Format Cell option.
- A dialog box of Format Cells will open. We need to select Percentage option.
- Select Number of decimal places as required. By default, it is 2. The press OK.
Examples on Formula of Percentage in Excel
Let’s understand how to implement Formula of Percentage in Excel with some examples.
Formula of Percentage in Excel – Example # 1
If we want to find the value of the percentage of a number, we have to multiply the percentage value by the number.
For example, if we want to calculate 50% of 1000, just multiply 1000 by 50%.
4.9 (5,813 ratings)
View Course
In the above figure, we need to find out the percentage in the value box.
Step 1: Select the cell B3
Step 2: Write the formula as = PRODUCT ( B1, B2)
Step 3: Press the Enter key.
Step 4: Result will show as 500.
This can be done in an alternate way too:
Step 1: Select the cell B3
Step 2: Write the formula as = B1* B2
Step 3: Press the Enter key.
- Result will show as 500.
Formula of Percentage in Excel – Example # 2
We can also find the percentage from the value and a number. We have to just use the mathematical formula as Value divided by Number.
Percentage = Value / Number
For example, What is the percentage of 500 from 1000?
In the figure, we have Number as 1000, Value as 500 and we have to find out the Percentage.
Step 1: Select the Cell B3
Step 2: Write the formula as = B2/B1
Step 3: Press the Enter key.
Step 4: Result may come in Decimal if the cell is not converted to a percentage. We have to convert the cell to Percentage.
Step 5: Select the cell B3
Step 6: Under Home tab >> under Number Group >> Click on % button to convert the numerical value of cell into percent value.
- Result is now converted to percentage value.
Formula of Percentage in Excel – Example # 3
We can find the percentage of each number from the total value of the data sets. We have to just use the mathematical formula as Each Number of the Data Set divided by Sum of the total Data Set.
Percentage of Each Number = Each Number of the Data Set / Sum of the total Data Set
For Example, We need to find out the percentage of the Basic pay of each employee of the company.
Let us consider the example of Basic pay of the employees’ table.
Step 1: Select the cell A13 and Write Total Basic Pay.
Step 2: Select cell B13.
Step 3: Write the summation formula as = Sum (B3:B12) or =SUM(B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,)
Step 4: Press Enter
Step 5: Result of the total basic Pay will appear.
Step 6: Select the cell C2 and Write Percentage.
Step 7: Select the cell C3
Step 8: Write down the formula as =B3/$B$13. Fix the cell B13 using $ sign or by pressing F4 after selecting the cell B13.
Step 9: Result may come in Decimal if the cell is not converted to a percentage. We have to convert the cell to Percentage.
Step 10: Under Home tab >> under Number Group >> Click on % button to convert the numerical value of cell into percent value.
Step 11: Select the cell C3
Step 12: Either copy the cell C3 and paste in the range C4: C12 or drag down the formula from C3 to C12 cell to copy the formula in all the cells with the required Percentage format.
Formula of Percentage in Excel – Example # 4
We can also find an increase or decrease in change in percentage between the two values. We have to just use the mathematical formula as the difference between the Numbers divided by the first number.
Change in percentage = (2nd Number – 1st Number) * 1st Number
For example, We need to find the profit percentage on the cost price.
Step 1: Select the cell F2 and write the formula as = (E2-D2)/D2
Step 2: Press the Enter key.
Step 3: Under Home tab >> under Number Group >> Click on % button to convert the numerical value of cell into percent value.
Step 4: Drag down the formula from F2 to F15.
Things to Remember About Formula of Percentage in Excel
- If the numerator is zero, an error named #DIV/0! will appear.
- While we compare and find the increase or decrease in change in percentage, we will get a result as a negative percentage value, if the numerator or denominator value is less than zero.
- By using the IFERROR function, we can avoid getting any type of errors in the percentage calculation.
- To convert the result from decimal to a percentage value, we need to change the formatting of the cells or range.
Recommended Articles
This has been a guide to Formula of Percentage in Excel. Here we discussed methods to Implement Formula of Percentage in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –
