How to add percentage to a number: formula
To add percentage to a number, use the universal formula:
number + (number × percentage / 100)For example, to add 20 percent to the number 500: 500 + (500 × 20 / 100) = 600.
Calculation examples
- Let's calculate how to add 10 percent to the number 200: 200 + (200 × 0.1) = 220.
- How to add 15 percent to a number: 100 + (100 × 0.15) = 115.
- To add 30 percent to the number 300: 300 + (300 × 0.3) = 390.
- Add 40 percent to the number 50: 50 + (50 × 0.4) = 70.
- Add 5 percent to the number 1000: 1000 + 50 = 1050.
How to add percentage to a number in Excel
In cell A1, specify the number. To add a percentage, enter the formula in another cell: =A1*(1+20%), where 20% is your percentage.