Microsoft Excel is an application that allows you to manipulate numeric and alphanumeric data through a spreadsheet. These data are arranged in cells, which are usually distributed in a two-dimensional form of rows and columns. In Excel, the cell is the information base of the spreadsheet. You must use the cell to insert the values and the formulas to make the different calculations, such as obtaining a percentage in Excel.
Steps To Follow:1
Let’s give an example to calculate a percentage: if 50 people work in an office and only 20 go up the stairs, what percentage do those who go up the stairs represent with respect to the total number of workers?
To get the percentage in Excel, you must select any cell, for example, D5.
Steps To Follow:2
In this way, you must apply a rule of three
50 — 100%
20 — x
That is, if 50 people are 100%, what percentage is 20?
To perform this mathematical operation in Excel and find the percentage, you must write in the selected cell ” = (20 / 50) * 100 ” (without the quotes).
Steps To Follow:3
Press the Enter key and you will see how Excel gives you the desired percentage, in our example: 40. In this way, we can say that if 50 people work in an office and 20 go up the stairs, it is 40% of the workers who use the stairs instead of the elevator.
Steps To Follow:4
Another way to get a percentage in Excel is by using values previously entered in the spreadsheet. Continuing with the previous example, we will write the values that the statement of the exercise gives us as if it were a rule of three.
We select an empty cell again, in this case, D5 too, and write an equals symbol: =
Steps To Follow:5
Next, you must select the cells that contain the numerical values and write the mathematical symbols of the relevant operations and finally press the Enter or Enter key. In this way, the formula will be formed by the alphanumeric codes of the cells, in our example: “=A3/A2*B2”
It should be noted that the symbols that you must in Excel are:
- + (plus symbol) to add
- – (dash) to subtract
- * (asterisk) to multiply
- / (sidebar to the left) to split
If you want to read more articles similar to How to get the percentage in excel, we recommend you visit our Software category.
