More recently, all the necessary calculations were done manually or using calculators. This was time consuming, especially when it comes to banking or the work of accountants in large enterprises. But today the Excel application comes to the rescue for working with numbers and tables. You can do complex calculations in it, but those who have recently begun to master the application have a very reasonable question: how to calculate percentages in Excel.
Instructions
Step 1
In order to calculate the percentage in Excel, you must enter an equal sign in the cell in which the result should be displayed. After that, the percentage to be calculated is entered into the address of the cell that contains the desired number. To do this, click on the required cell, put the multiplication sign and enter the percentage that needs to be calculated. Immediately after the number, a "percentage" sign is placed, the Enter key is pressed on the keyboard, and the required answer will be displayed in the cell. Moreover, if you change the original number or percentage, then the final result will also be different.
Step 2
When working with tables, quite often the percentage is taken out in a separate cell. To get the result, you need to put an equal sign, click on the contents of the first cell with the main number, enter the multiplication sign, click on the cell that contains the percentage and press Enter. As a result, the desired result will be displayed.
Step 3
You can also remember your school years and apply the percentage calculation. Any absolute value is represented as 100%, and if it is necessary to calculate a percentage of it, then it is advisable to apply a formula in which the initial indicator is multiplied by the number of desired percentages and divided by 100. Through the equal sign, the formula is entered into a cell and Enter is pressed. Thus, you can quickly calculate the percentage in Excel in several simple ways.
