The main work in Excel involves numbers and calculations. Often the user is faced with the task of adding a percentage to a number. Suppose you want to analyze the growth of sales by a certain percentage, and to do this you need to add this same percentage to the original value. In this article you will learn how to perform this operation in Excel.
How to manually add a percentage to a number
For example, you want to know the value of a certain number with a percentage added to it. To perform this simple arithmetic, you will need to enter the formula below in a free cell or formula line.
The formula looks as follows:
“=(digit) + (digit) * (percent value) %”.
Let’s look at a concrete example. We need to add 20% of the same number to the number 350. To do this, write the following expression in the cell/line of formulas: “=350+350*20%”.
After that, we press “Enter” and get the finished result in the selected cell.
Formula to add a percentage in excel
Earlier we already figured out how to do the calculations manually. Now let’s look at how to make calculations with data already entered in the table.
First, we need to determine the cell in which the final result will be calculated.
In this cell, write the sign “=”, then select the cell with the original number to which you want to add percent, then write the sign “+”, select the cell with the original number again, add to it the multiplication sign “*” and print the percent value as a number, not forgetting to add the percent sign “%” in the end.
That’s really all. All you have to do is to press “Enter” and the result will be displayed in the cell with the formula.
There are times when you want to calculate all the data in a column in this way. To do this, you don’t need to write a formula for each new row at all.
To automatically calculate the entire column, place the mouse cursor in the bottom right corner of the cell so that the cursor takes the form of a plus. Then left-click this corner and drag the formula to the rest of the cells below for which you want to make the calculation.
As a result, the results for each row in the column will be calculated.
How to add a percentage to a whole column in excel
There are cases where we have an even more populated table in which, along with the original values in one column, there is also data with percentages in another, and the percentage values may be different from each other.
In this case, the procedure is almost identical to the previous one, except that in the formula we replace the specific percentage value with the cell containing the percentage value.
Then we click “Enter” and get the result.
The formula can also be stretched to the remaining rows of the table if necessary
As you have just seen, there is nothing difficult about performing a task such as adding a percentage to a number in an Excel spreadsheet. However, most users make mistakes in writing calculation formulas. The above examples of information will help to avoid possible mistakes.