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.

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:

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

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.

The result after conversion

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)

Increasing the Price by 10%

#  Amount * (1 – Decrement %)

=> Price * (1 – Discount) – For decreasing the Price value by the Discount percentage.

=> B2*(1-C2)

Decreasing the Price by 10%

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)

Increasing the Price by 10%

# Amount – (Amount * Decrement %)

=> Price – (Price * Discount) – For decreasing the Price value by the Discount percentage.

=> B2-(B2*C2)

Decreasing the Price by 10%

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.]

Calculating the Percentage of Total

[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 the Amount

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

Calculating the Total

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.

Further Readings

Tags:

Chinmoy Mondol

Chinmoy Mondol

Greetings! Thank you for visiting my profile. I am Chinmoy Mondol. I am a conscientious, tech enthusiast individual with a voracious appetite for knowledge and a desire to learn more. I graduated from American International University-Bangladesh with a Bachelor's Degree in Computer Science and Engineering. I enjoy using my skills to contribute to the exciting technological advances that happen every day. Constant advancement and personal development are my guiding principles.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo