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.

**Table of Contents**hide

## Download the Workbook

You can download the workbook that I used in this article from below and practice with it by yourself.

## 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:

- Select the cell or cells you want to convert to percentages (In my case,
**Cell C2 to C11**). - 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:

- Select the cell or cells you want to show the output to.
- Enter
**equal (=) sign**. It should enable you to type formulas. - 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:

- Select the cell or cells you want to show the output to.
- Enter
**equal (=) sign**. It should enable you to type formulas. - 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:

- 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. - Enter
**equal (=) sign**. It should enable you to type formulas. - 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.