The package for creating Microsoft Office documents is a popular software suite. Every person who typed information on a computer, compiled lists, calculated various indicators, and created presentations to demonstrate them to an audience is familiar with them. Among the programs of the package, Excel deserves special attention - an assistant in carrying out various calculations. To determine the% of a number, adding percentage values, it is worth knowing some nuances that will simplify the calculations.
Cell format
Before entering a formula into a cell, set the format to "percent". In this case, there is no need to enter additional steps. A "%" icon will be automatically placed next to the received value.
To do this, put the mouse cursor on the desired cell. By clicking the right mouse button, a menu will appear. You must select the cell format, then percentage.
Basic Formula
Excel has general rules for calculating interest. After selecting the cell format, enterformula.
The basic percentage formula in Excel is written as follows:
- The “=” icon is put.
- The cursor presses the value whose percentage is to be calculated.
- Put an oblique dividing line from the keyboard.
- Then click on the cell to which the percentage is calculated.
Calculate interest in Excel in a column
Sometimes it is necessary to calculate percentages of values that are located in columns. To do this, you need to enter the basic percentage formula in Excel in the first cell of the column, then, by clicking in the lower right corner of the cell, “drag” down to calculate the desired values.
Calculate percentages in rows
When data is written horizontally, in rows, interest is calculated in the same way as in columns. After selecting the cell format, the percentage formula is entered into the Excel table.
The "equal" icon is put, the cell is selected, the percentage of which is to be calculated. Then - the line of division. The value of the cell to which you want to calculate the percentage is selected.
After that, you need to click on the lower right corner of the cell with the cursor and drag it to the side until the required values are calculated.
Calculation from the total amount
If necessary, calculate, for example, the specific gravity of the total amount of a row or column, the calculation formula needs to be slightly changed. First of all, it is desirable to calculate the total amount of the range.
To do this, you can put the sign "=" and highlighting alternate cells, press the "+" sign between them. Then the Enter key is pressed.
Also, after putting down "=", type SUM on the keyboard, open the bracket, enter the range of cells for summation, and then press Enter.
When calculating the share of the total amount, after the introduction of the "equal" sign, in the cells whose share must be calculated, the "$" signs are placed before the row number and the column letter. This icon "fixes" the relationship between them. Without this sign, interest will be calculated from other cells.
Adding percentages to a number
Before you add percentages to a number in Excel, you should familiarize yourself with the general calculation formula. Do not forget that a percentage is a hundredth of a number.
If you need to add Excel percentages to a column of values, you can enter the following formula: icon "=", the cell to which you want to add percentages, the percentage value, the "/" sign, the same cell to which percentages are added, multiplied one hundred.
If the percentage value is placed in a separate column or cell, the formula will look different.
Before Excel adds a percentage to a number located in another column, the formula must take the form: equals sign, cell to which you want to add percentages, plus sign, cell with percentage value with signs " $" multiplied by the cell to which we are adding the percentage. Provided that the latter format is set to "percentage".
If interest is inone column, and the values to which they need to be added are in another, then the formula that allows Excel to add percentages to a number will take the following form: the equal sign, the cell with the value, the plus sign, the cell with the percentage multiplied by cell with a number. It is important not to confuse cell formats! Percentage format can only be set for cells with %.
When calculating % in Excel, remember to set the cell format for percentage values. For cells with numbers, a numeric value is used, for percentages, a percentage value. You can select it from the menu that appears after pressing the right mouse button.
In all formulas for calculating interest, the sign "=" is obligatory. If you do not put it, the formula will not calculate.
The calculations in columns and rows are similar. Many operations are performed by "stretching" cells. To do this, enter the calculation formula and click on the cross in the lower right corner of the cell. Then use the cursor to "stretch" the value down, up or in the desired direction. The calculation will happen automatically.
There are several formulas that allow you to add percentages to a number in Excel. It depends on whether you need to add a specific value or data from another column.
If you need to add percentages of one cell, calculate the percentage of one value, use the "$" sign, which is installed in the formula bar before the line number and column letter.
