# How to Add Percentages to Numbers in Excel (4 Easy Ways)

Adding percentage to a number in MS Excel generally means two things. One is that you want to convert a number to a certain percentage, and the other is that you want to increase a value by a particular rate. In this article, Iâ€™ve addressed both of these concerns and also covered the basics and other commonplace uses of percentages in MS Excel.

## 4 Ways to Add Percentages to Numbers in MS Excel

â€śPercentâ€ť comes from the Latin per centum, which means â€śhundredâ€ť or â€śby the hundred.â€ť So it is a fraction of 100. Letâ€™s take an example for a better understanding.

Suppose you have 50 mangoes and you gave 25 of them to your friend. Now, if you want to calculate the value of mangos you gave to your friend in percentage, then you have to follow this formula:

# (Amount / Total) * 100 = Value in percentage, %

=> (Amount of mangos to gave/ Total number of mangos)*100 = How much you gave in percentage.

=> (25/50)*100 = 50%

So, you gave 50% or half of your mangoes to your friend. I hope you have got a clear idea now.

### 1. Converting numbers to percentages

This method shows how you can convert cells with numerical values to percentage values using the default options provided by Excel.

Follow these steps for applying this solution:

1. Select the cell or cells you want to convert to percentages (In my case, Cell C2 to C11).
2. Go to Home and select the Percent Style option under the Number section, or you can press Ctrl+Shift+% as well.

It will multiply the cells with 100 to convert the number into percentages and add a % sign at the end of the values as an indicator.

### 2. Increment/Decrement of numbers in percentage

This method shows how you can increase or decrease a number by a certain percentage. There are 2 ways of applying this method. They are as follows:

#### i) Using the Multiplication method

Follow these steps for applying this solution:

1. Select the cell or cells you want to show the output to.
2. Enter equal (=) sign. It should enable you to type formulas.
3. Now, enter the following formula for your dataset and hit the Enter button.

# Amount * (1 + Increment %)

=> Price * (1 + Price Increase) â€“ For increasing the Price value by the Prince Increase percentage.

=> B2*(1+D2)

#Â  Amount * (1 â€“ Decrement %)

=> Price * (1 â€“ Discount) â€“ For decreasing the Price value by the Discount percentage.

=> B2*(1-C2)

#### ii) Using the Addition/Subtraction method

Follow these steps for applying this solution:

1. Select the cell or cells you want to show the output to.
2. Enter equal (=) sign. It should enable you to type formulas.
3. Now, enter the following formula for your dataset and hit the Enter button.

# Amount + (Amount * Increment %)

=> Price + (Price * Price Increase) â€“ For increasing the Price value by the Prince Increase percentage.

=> B2+(B2*D2)

# Amount â€“ (Amount * Decrement %)

=> Price â€“ (Price * Discount) â€“ For decreasing the Price value by the Discount percentage.

=> B2-(B2*C2)

### 3. Percentage of Total

This method shows you how you can calculate the percentage of the total amount.

Follow these steps for applying this solution:

1. Select the cell or cells you want to show the output to. If the cell is not into Percent Style format, then you have to select it to that format first. See the 1st section of this article for performing the operation.
2. Enter equal (=) sign. It should enable you to type formulas.
3. Now, enter the following formula for your dataset and hit the Enter button.

# Amount / Total

=> B2/\$B\$12 [Here, theÂ B12 cellÂ is locked. Thatâ€™s why theÂ dollar (\$)Â sign. It is known as theÂ Absolute Symbol. It makes the cell references absolute and doesnâ€™t allow any changes. You can lock a cell by selecting the cell and pressing theÂ F4Â button.]

[Note: You can simply copy the formula to other cells and calculate their total percentage. See this article for copying formulas in Excel.]

### 4. Amount and Total from Percentage

#### Calculating Amount:

By following this method, you can calculate the Amount if you have the Percentage and the Total values.

The formula for percentage can be written as follows:

# Amount / Total = Percentage

=> Amount = Total * Percentage `= ``B2*C2`

#### Calculating Total:

By following this method, you can calculate the Total if you have the Percentage and the Amount values.

The formula for percentage can be written as follows:

# Amount / Total = Percentage

=> Total = Amount / Percentage = B2/C2

## Conclusion

Working with percentages in Excel can be a nightmare if you donâ€™t understand the basic usages. In this article, I have attempted to simplify such tasks by narrowing down the fundamentals and applications of percentage (%) in MS Excel. I hope you were able to solve your problem. Please leave a comment if you have any suggestions or questions. Thank you.