The package for creating Microsoft Office documents is a popular software package. They are familiar with every person who typed information on a computer, compiled lists, calculated various kinds of indicators, created presentations to demonstrate their audience. Among the programs in the package, Excel deserves special attention - an assistant in various calculations. To determine% of the number, adding percentage values, you should know some nuances that will simplify the calculations.
Cell format
Before entering the formula into the cell, the format “percentage” should be set. In this case, there is no need to enter additional actions. Next to the received value, the “%” icon will be automatically placed.
To do this, put the mouse cursor on the desired cell. By right-clicking, a menu appears. You must select a cell format, then a percentage.
Basic formula
In Excel there are general rules for calculating interest. After selecting a cell format, a formula is entered.
The basic percent formula in Excel is written as follows:
- The “=” sign is put.
- The cursor presses the value whose percentage you want to calculate.
- Put an oblique line of division with the keyboard.
- Then the cell to which the percentage is calculated is pressed.
Interest calculation in Excel in the column
Sometimes it is necessary to calculate the percentage of values that are located in columns. To do this, you need to enter the basic percent formula in Excel in the first cell of the column, then, clicking in the lower right corner of the cell, "stretch" down to calculate the desired values.
Calculation of percentages in rows
When writing data horizontally, in rows, interest is calculated in the same way as in columns. After selecting the cell format, the percent formula is entered into the Excel spreadsheet.
An equal sign is placed, a cell is selected whose percentages must be calculated. Then - the line of division. The value of the cell to which the percentage is to be calculated is selected.
Then, with the cursor, click on the lower right corner of the cell and drag it to the side until the required values are calculated.
Calculation of the total amount
If necessary, calculate, for example, the specific gravity of the total row or column total, the calculation formula needs to be slightly changed. First of all, it is advisable to calculate the total amount of the range.
To do this, you can put the "=" sign and, highlighting the cells in turn, click the "+" sign between them. Then the Enter key is pressed.
You can also type “SUM” on the keyboard, open the bracket, enter a range of cells to sum, and then press Enter.
When calculating the share of the total amount, after the introduction of the equal sign, in the cells whose share is to be calculated, the $ signs are placed in front of the row number and column letter. This icon “fixes” the relationship between them. Without this sign, percentages will be calculated from other cells.
Add percent to number
Before adding interest to a number in Excel, you should familiarize yourself with the general calculation formula. Do not forget that percentage is one hundredth of a number.
If you want to add Excel percentages to the value column, you can enter the following formula: the “=” sign, the cell to which percentages must be added, the percent value, the “/” sign, the same cell to which percentages multiplied by one hundred are added.
If the percent value is moved to a separate column or cell, the formula will have a different look.
Before adding a percentage to the number located in another column in Excel, the formula should take the form: equal sign, cell to which percent should be added, plus sign, cell with percent value with "$" signs, multiplied by cell to which we add interest. Provided that the latter format is set to "percentage".
If percentages are in one 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: equal sign, cell with value, plus sign, cell with percent multiplied by a cell with a number. It is important not to confuse the cell formats! The 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 is used, for percent, a percentage. You can select it from the menu that appears after pressing the right mouse button.
In all interest calculation formulas, the “=” sign is required. If you do not put it, the formula will not calculate.
The calculations in columns and rows are similar. Many operations are performed by “pulling” the cells. To do this, enter the calculation formula and click on the cross in the lower right corner of the cell. Then, with the cursor, “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 numbers in Excel. It depends on whether you need to add a specific value or the data of another column.
If you need to add the percentages of one cell, calculate the fraction of one value, use the "$" icon, which is installed in the formula bar before the line number and the column letter.