Percentage calculation in Excel - how it works
If you have to perform the calculation in Excel, the percentage calculation is not long in coming. We show you how to calculate the percentages.
Simple percentage calculation in Excel
- If you select a cell and click the percent button under the "Start" tab, the cell content is displayed as a percentage. You can have the percent sign inserted automatically as you type. If there is already a number in the cell, it is calculated 100 times (20 becomes 2000%).
- If a field is marked as a percentage field or if you have simply inserted the percentage number yourself, Excel automatically calculates the percentage numbers. You can therefore multiply or divide two cells consisting of a number and a percentage. It is also possible to incorporate the percentages into a longer calculation.
- Example: In field A1 there is a 7, in A2 a 50. In field A3 we divide the two numbers with the command "= A1 / A2". So that the result is displayed in percent, we click on the percent button at the top of the "Start" tab.
More tips on percentage calculation in Excel
- Simple calculation: Even the smallest invoice can be entered easily. For example, you can use the command "= 6 * 25%" to do a single percentage calculation without much effort.
- Decimal places: Next to the percent button you will find the button for showing the decimal places. These are hidden by default in the percentage calculation.
- Formulas: If there are certain mathematical problems that you want to solve using percentages, you will find several instructions on this Microsoft website.
Tip: We will show you how to calculate a partial sum in Excel in the next practical tip.