A short tutorial on how to do percentages in excel sheet with simple steps.
Calculating percentage in excel is made easy by using formulas. You just need to enter the formula in the formula tab. Learn here how to calculate percentage in excel.
Our tutorial gives you the answer for how to formulate a percentage in excel. In Excel, you can create a formula by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. The formula which you type here also appears in the formula text box at the top. You can either type the formula in the cell or the formula text box or just click on the cells which you want to include in your formula and add the operator signs such as +, -, *, /.
Consider the below table with employee salary details of Basic Salary, DA and HRA. The last column of the table calculates how much percentage is the basic salary in the total salary.
The basic formula for calculating a percentage is (part / total) * 100. You can enter this formula in the result cell by typing manually or by selecting the cells by clicking.
When you press enter, you get the result as:
Similarly you can make the percentage calculations for the rest of the columns, by just entering the same formula in all the columns, which will give the result as below.
If you want to display the percentage symbol in the result box, you can change the formula from (part/total)*100 to just part/total and change the format of the result cells as "Percentage" to reflect the % symbol in the result. Also set the number of decimal places to be 2, as shown below.
Which will give the result as:
Change the number format to percentage by right-clicking and selecting the "Format Cells" option in the menu.
Finally, you can see the result cells showing the percentages.